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