Pivot Table Total Issue

[Karthick30]

Hi ,

 I am using Pivot table. In that measure, I am giving If condition and result is coming fine.. but total is coming as 0.

[Vegar]

You're holding back some important information.  What does your measure expression look like and what are the names of the dimensions in your pivot table?

You do mention that  you have an IF statement.  Could it be that the if statement returns null()/false when you have more than one dimension values on one row.

Try to get your expression to work using no dimensions in your table, then it will probably work when you add dimensions afterwards. 

[Karthick30]

Hi @Vegar ,

 Please find the measure value as below

f(A='India',sum({<B={'Annual Plan'},A={'India'}>}L)/1000 - below(sum({<B={'Annual Plan'}>}L)/1000) - below(below(sum({<B={'Annual Plan'}>}L)/1000)),
sum( {<B={'Annual Plan'}>}L)/1000)

L is the value we are summing

Result I am getting is 

3088 Total is not correct. Actual total is 2908. 

[Mark_Little]

HI @Karthick30 

First thing to try is the totaling function

Change to sum.

[Karthick30]

@Mark_Little . we dont have that option in Pivot table. Its available only in Normal native chart.