Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Using this expression i get this table:
sum(SALES)/ sum(total(SALES))
Date | Actual 2016 | Prev Year | Target 2016 |
Distribution | SALES | SALES | SALES |
A | 30,3% | 10,9% | 7,7% |
B | -0,9% | 15,7% | 22,0% |
C | 3,2% | 4,1% | 6,9% |
100,0% |
What i need is to separate the percentage by dimensión DATE
Date | Actual 2016 | Prev Year | Target 2016 |
Distribution | SALES | SALES | SALES |
A | 30,0% | 20,0% | 13,0% |
B | 20,0% | 20,0% | 10,0% |
C | 50,0% | 60,0% | 77,0% |
total | 100,0% | 100,0% | 100,0% |
Could you help me please?
Thanks
Hi Belen,
Use this expression Sum(Sales)/Sum(TOTAL<Company> Sales).
Regards
Chirag.
Could you send an example
hi Belen,
I am little confused with your requirement is your ask to change the label of distribution dimension to date?
In the first chart the sum of the percentages is 100%.
What i need is the weights in the dimensión "date": in each column. Is this posible?
I do not know if i explain myself well......
Date | Actual 2016 | Prev Year | Target 2016 | |
Distribution | SALES | SALES | SALES | |
A | 10 | 18 | 32 | |
B | 20 | 15 | 40 | |
C | 5 | 3 | 10 | |
what i have | ||||
Date | Actual 2016 | Prev Year | Target 2016 | |
Distribution | SALES | SALES | SALES | |
A | 7% | 12% | 21% | |
B | 13% | 10% | 26% | |
C | 3% | 2% | 7% | |
TOTAL | 23% | 24% | 54% | 100% |
what i NEED | ||||
Date | Actual 2016 | Prev Year | Target 2016 | |
Distribution | SALES | SALES | SALES | |
A | 29% | 50% | 39% | |
B | 57% | 42% | 49% | |
C | 14% | 8% | 12% | |
TOTAL | 100% | 100% | 100% | 300% |
Try with this expression:
Sum(Sales)/Sum(Aggr(Sales, Distribution,Date))
let me know
Hi Belen,
Use this expression Sum(Sales)/Sum(TOTAL<Company> Sales).
Regards
Chirag.
Thanks