Row Total shows wrong data

[CHAY-92]

Hi all,

I m very confused about pivot default row  total options. If I select a year I need to pull 3 years of data with sum(sales)>50000 and count of those customers.

Dim: customer 

Measure 1 : if(sum(<year=>sales)>50000,sum(<year=>sales))

Measure 2;

Sum(aggr(Count(customer),customer) 

But I am getting wrong numbers 🙃 😕 

Kindly guide me how I will correct my error

[CHAY-92]

Hi vinieme,

You are Amazing 👏 Thank you so much for your Help.you saved my day 🙏🙏🙏🙏

[vinieme12]

happy to help 🙂