How to make sales for example as ABCDEFGH analysis

[#1]

Hi!

I have a straight table as below

Customer   as dimension

Revenue (sum(Price))     as expression

% Revenue (sum(Price); checked Relative chart properties)      as expression

Revenue cumulative (sum(Price); checked Full Accumulation chart properties)    as expression

% Revenue cumulative (sum(Price) checked; Relative and Full Accumulation)    as expression

Now I would like to make additional selection to user as ABCDEFGH clients.

I assume that below example would be calculated from % Revenue cumulative expression  as comparison to top sales which is calculated from % Revenue expression

For example:

A clients 30 % from sales

B clients 20 % from sales

C clients 15 % from sales

D clients 15 % from sales

E clients 10 % from sales

F clients 5 % from sales

G clients 3 % from sales

H clients 2 % from sales

If user is selecting A clients then it would only show clients who are buying 30 % from whole sales (% Revenue cumulative)

If user is selecting B clients then it would only show clients who are buying 20 % from whole sales (% Revenue cumulative) NOT A,C,D,E,F,G,H clients

If user is selecting C clients then it would only show clients who are buying 15 % from whole sales (% Revenue cumulative) NOT A,B,D,E,F,G,H clients

Is it possible to create statistics like this?

Thank you very much in advance!

[#2]

Hi,

The best would you create a table with parallel sorting by date customer, because every day the customer classification can change.

By Rebeca