how to determine how many customers are under and over a $ value

[#1]

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!

[its_anandrjs]

Create % buckets in the data model and then use that bucket in the presentation.

[#3]

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.

[MK_QSL]

Your sample data file can help us to answer you quickly...

[Anonymous]

The buckets should be created in calculated dimension (using "if" conditions, and aggr by customer), and chart expression is count(distinct customer)

[#6]

Thanks Michael, I will give that a try.

[#7]

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!

[Anonymous]

Now I have to second Manish Kachhia - it would be easier to help if you upload a sample app...

[#9]

Agreed, i wish I could, but unfortunately, this is data that is confidential. Is there any direction you can give?

[MK_QSL]

Yes, but you can definitely create a sample data file / excel file similar to your original one with dummy data...