Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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.
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 . we dont have that option in Pivot table. Its available only in Normal native chart.