Let us say I have an application that tracks my inventory of tasty fruit. I have a Data Form called Fruits, which has a Type field (Apples, Oranges), and a Status field (Unripe, Ripe, Rotten). Each individual fruit is a row in the table created by this Data Form.

    

I would like to see at a glance how many of each type of fruit I have, and what proportion of them are in what status. To this end, I have created a PIVOTCHART, which displays a stacked bar chart showing me that I have some number of Apples, and of those Apples x are unripe, y are ripe, z are rotten, and so on.

    

What I would like to do now, is to create a table that shows how those quantities change over time. For example, it might show that Fruits had x Unripe Apples on the 1st, then x-1 Unripe Apples on the 2nd, then x-2 Unripe Apples on the 3rd, and so on, displayed in whatever way I please with another pivot chart.

I could schedule a script that runs each day at Midnight, and it would run something like (the below is 0% proper deluge, and is just to give an idea of the logic):

    

    update FruitSummary

    

    listoffruittypes =...

    listoffruitstatuses = ...

    

    for each x in listoffruittypes

        for each y in listoffruitstatuses

            FruitSummaryCount = Fruits[type==x && status == y].count()...

            add new row to FruitSummary

                SummaryDate = [current date]

                FruitType = x

                FruitStatus = y

                Count = FruitSummaryCount

                ...

    

The overall result being that each day it would add a bunch of rows to Fruit Summary counting occurrences of each type of fruit and status. Then I can create a PivotChart of FruitSummary, group by date, then by type, then by status, and let the result be the sum... and Bob's your uncle.