Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi, I am attempting to report at different summary levels (area / district / country) how many customers have purchased under 75%, between 75 and 110% and over 110% of a preset value. I don't need or want to have to list all the customers individually.
any help / hints would be appreciated!
You can use the same as calculated dimension in UI side
Create % buckets in the data model and then use that bucket in the presentation.
Thanks Anand, I considered that, but the calculation needs to take into account the product(s) and time frame which the user can change (as well as the preset value as a future requirement). My apologies for not stating that upfront.
Your sample data file can help us to answer you quickly...
The buckets should be created in calculated dimension (using "if" conditions, and aggr by customer), and chart expression is count(distinct customer)
Thanks Michael, I will give that a try.
HI, getting back to this now, I have the calculated dimension working as
=if ($(vDIM%Achieved) < 2,1,0)
where vDIM%Achieved is
aggr(sum([Sales]),[Cust_ID]) / aggr(sum([PlannedSales]),[Cust_ID])
this works, it places a '1' in column for customers with less than '2' sales (actually 200%)
have two more columns checking for between 2 and 4, and over 4
how do I now get totals of these dimensions at area/district/country levels?
thanks for the help!
Now I have to second Manish Kachhia - it would be easier to help if you upload a sample app...
Agreed, i wish I could, but unfortunately, this is data that is confidential. Is there any direction you can give?
Yes, but you can definitely create a sample data file / excel file similar to your original one with dummy data...