topic Re: Pivot Table Total Issue in App Development

Pivot Table Total Issue

Karthick30 — Wed, 26 Oct 2022 17:27:28 GMT

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.

Re: Pivot Table Total Issue

Vegar — Thu, 27 Oct 2022 04:31:59 GMT

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.

Re: Pivot Table Total Issue

Karthick30 — Thu, 27 Oct 2022 05:34:36 GMT

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.

Re: Pivot Table Total Issue

Mark_Little — Thu, 27 Oct 2022 06:44:30 GMT

HI @Karthick30

First thing to try is the totaling function

Change to sum.

Re: Pivot Table Total Issue

Karthick30 — Thu, 27 Oct 2022 06:55:03 GMT

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