1 Reply Latest reply: Mar 26, 2013 10:35 AM by Rebeca Gums RSS

    How to make sales for example as ABCDEFGH analysis

      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!