Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
attached report is working fine using back end script method. but i'm looking forward to do in front end instead of doing in back end script method.
just need to derive the Regular sales % calculated measure (highlighted red is expected output.)
Thanks
Deva
This:
=Sum(Aggr(If(((Sum(TotalGrossPrice)-Sum(TotalNetPrice))/Sum(TotalGrossPrice)) < 0.15, Sum(TotalNetPrice)), Country, Product))/SUM(TOTAL <Country,Product> TotalNetPrice)
This:
=Sum(Aggr(If(((Sum(TotalGrossPrice)-Sum(TotalNetPrice))/Sum(TotalGrossPrice)) < 0.15, Sum(TotalNetPrice)), Country, Product))/SUM(TOTAL <Country,Product> TotalNetPrice)
Hi Sunny,
It's Working perfectly, Thanks
Another approach using set analysis
=Sum({<Key = {"=((Sum(TotalGrossPrice)-Sum(TotalNetPrice))/Sum(TotalGrossPrice)) < 0.15"}>} TotalNetPrice)/SUM(TOTAL <Country,Product> TotalNetPrice)