Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
I have a following bar chart, that represents percentage of product sold by Sales Reps. So the below chart would tell me that brown products are old more then the pink product.
Problem: When I click on a single product then every bar becomes 100% like it shows below
Instead of all 100% I would like to see comparison between reps. Is it possible?
Assuming you current expression is like this
Sum(Sales)/Sum(TOTAL <[Sales Rep]> Sales)
Add this in there
Sum(Sales)/Sum(TOTAL <[Sales Rep]> {<Product>} Sales)
Assuming you current expression is like this
Sum(Sales)/Sum(TOTAL <[Sales Rep]> Sales)
Add this in there
Sum(Sales)/Sum(TOTAL <[Sales Rep]> {<Product>} Sales)
Thank you Shani Dev