pivot table calculation

[#1]

Hi all,

I wrote the if condition in pivot table with one dimension.

the value showing in pivot chart is correct.

but when i add another dimension like sub category the value getting changed.

is there anyway to avoid this problem.

PFA.

thanks in advance.

[jagan]

Hi,

Please check the attachment.

Hope this helps you.

Regards,

Jagan.

[#3]

Hi

thanks for ur reply,

i forgot one thing.

only category should contain positive value in one chart and negative in another chart.

but sub category may negative or positive values or both.

ur application show only positive or negative values.

thanks in advance