Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hi check the attach file
the discount test expression
you cant use set analysis because it only selects a category as catgeory is in your dimension it cant work
the trick is to use total in your expresssion
Hi,
Try with this expression
=if(Category='Budget vs Actual',Sum([Gross Sales]), sum( [Total Discount]) / sum(TOTAL <Year,Category> [Gross Sales]))
Hope it helps
Celambarasan
hi check the attach file
the discount test expression
you cant use set analysis because it only selects a category as catgeory is in your dimension it cant work
the trick is to use total in your expresssion
That worked perfectly - Thanks! I didn't realize you can do an if statement inside of an aggregation!