Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Hi,
The best would you create a table with parallel sorting by date customer, because every day the customer classification can change.
By Rebeca