Totals not correct

[nareshthavidishetty]

Hi,

I have used pivot table but the totals are not matching.Below is the expression.

Expression:

if(sum(total_dec_app) > sum(aggr(sum(customer_id_count),store)),sum(total_dec_app) - sum(aggr(sum(customer_id_count),store)),0)

Below is the image for reference.

Thanks..

[Anil_Babu_Samineni]

When you say Total is not matched, You may describe more. And then, I would recommend to share sample data and expected output which demonstrates the issue

Expression seems okay to me

[nareshthavidishetty]

Yes the total is not matching..

[PrashantSangle]

Hi,

try below.

1: sum(aggr(sum(if(total_dec_app > customer_id_count,total_dec_app - customer_id_count,0),store))

or
2: if(sum(total_dec_app) > sum(aggr(sum(customer_id_count),store)),sum(aggr(sum(total_dec_app),store)) - sum(aggr(sum(customer_id_count),store)),0)

Regards

[HirisH_V7]

Hi,

Can you post your sample data and elaborate your requirement.

I suggest to use dimensionality() for the totals fields. It will be helpful for grouping and using aggr efficiently in pivot.

-Hirish

[satheshreddy]

Hi Naresh,

can you check the below EXP.

if(sum(total_dec_app) > aggr(sum(customer_id_count),store),sum(total_dec_app) - aggr(sum(customer_id_count),store),0)

Regards

Sathish

[#7]

Hi,

It is a bad approach to use if statements in your expressions as it is killing the app performance. Looking at the expression it might work as per design.

Please create a copy of your table and remove the store dimension. Then you will likely see the subtotals as you currently see.

Also you can add two expressions to see the behavior of the complete formula.statement. Expression 1 only contains: sum(total_dec_app). expression 2 contains sum(aggr(sum(customer_id_count),store)).

Kind regards,

Matthijs

[sunny_talwar]

How many dimensions do you have in your pivot table? Just 1 or are there more?