hi

[vignesh_s]

i used 'before' funtion to see hoe it works ,but im geting wrong result, can any help me out

[prma7799]

Try like this

before(sum(Price))

Please check this also

Missing Manual - Before() and After()

[vignesh_s]

i tried sum(price) too but the result is same

[prma7799]

Please share sample file with sample output

[Mark_Little]

Hi,

I think it is down to the way you are testing the function.

The Before function would return the value in the column prior, from the picture you only seem to have one column.

Try expanding you dimensions, have your second dimension along the top. of your table or try the above function.

Mark

[vignesh_s]

i tried wat usaid, but result is same

[vignesh_s]

[prma7799]

Like this??

[PrashantSangle · Accepted solution]

Since you are using Pivot chart but you are not pivoting any column in such case

You can user above() or below() as per your requirement.,

Regards,

[vignesh_s]

Thanks my doute got clarified