Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have some values which are separate for each of the months. However I would like it to be displayed in a rolling total so January would simply have January's figure in but February would have their value in as well as January's.
| Month | Value | Expected Value |
|---|---|---|
| Jan | 2 | 2 |
| Feb | 3 | 5 |
| Mar | 2 | 7 |
| April | 1 | 8 |
Use Month as Dimension.
Expression Label: ValueExp
Expression : Alt(Above([ValueExp]),0) +Sum(Value)
Or
Use Fully Accumulated option in the Expression tab under Accumulation section.
Hope it helps
Use Month as Dimension.
Expression Label: ValueExp
Expression : Alt(Above([ValueExp]),0) +Sum(Value)
Or
Use Fully Accumulated option in the Expression tab under Accumulation section.
Hope it helps
yeah.
Good answer........ ![]()
Regards,
Kabilan K