4 Replies Latest reply on Aug 21, 2016 1:32 AM by Prithvi I

# Grouping dynamically by SUM of Revenue

I have the attached data. Showing 26 clients and the revenue that they generate per month. I would like to group these clients in 3 categories <25,000, <100.000 & > 500.000. Depending on the total revenue per year a client is categorized.

I would like to get a table showing:

Year<25000<100000>500000
2014

No. of Clients

Total Revenue

No. of Clients

Total Revenue

No. of Clients

Total Revenue

2015

No. of Clients

Total Revenue

No. of Clients

Total Revenue

No. of Clients

Total Revenue

2016

No. of Clients

Total Revenue

No. of Clients

Total Revenue

No. of Clients

Total Revenue

Is this possible and if so how can I achieve this?

Thanks for all your help!

• ###### 1. Re: Grouping dynamically by SUM of Revenue

Found the solution myself:

New measurement field:

{FIXED [Client Name], YEAR([Date]) : SUM([Revenue])}

New dimension field:

IF [LOD Revenue] <= 25000 then "<25000"

ELSEIF [LOD Revenue] > 25000 AND [LOD Rvenue] <= 100000 THEN "<100000"

ELSEIF [LOD Revenue] > 100000 THEN ">100000" END

• ###### 2. Re: Grouping dynamically by SUM of Revenue

Hi Elberti,

Could you add your data here. I would also would like to try this myself.

Thanks,

Prithvi.

• ###### 3. Re: Grouping dynamically by SUM of Revenue

Hi Prithvi,

Best regards,

Elberti

• ###### 4. Re: Grouping dynamically by SUM of Revenue

Thanks Elberti,

That helped me in practising and understanding "Fixed" function in calculations.

Best Regards,

Prithvi