Set Analysis support required

[Saravanan024]

Support is needed to change the formula below when utilising the pivot chart option. I would prefer the accumulated value to be displayed by column rather than by row.  This will produce the outcome by adding the values side by side rather than using the rangesum above.

(

RangeSum(Above(TOTAL sum

( {$<,

Year={$(=max(Year))}>} Quantity_Consumed )

, 0, RowNo(TOTAL)))

)

-

RangeSum(Above(TOTAL sum( {<Flag = {'Target'}, Year={$(=max(Year))}>}[Target Value]), 0, Aggr(RowNo(), Month, Market))

)

[marcus_sommer · Accepted solution]

By using before() / after() instead of above() / below() and changing rowno() to columnno() you could adjust the direction from vertically to horizontally.