Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi vinieme,
You are Amazing 👏 Thank you so much for your Help.you saved my day 🙏🙏🙏🙏
happy to help 🙂