Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Community,
I have below table.
Product | Year | QTY |
A | 2011 | 10 |
A | 2012 | 20 |
A | 2013 | 20 |
B | 2011 | 20 |
B | 2012 | 30 |
B | 2013 | 40 |
C | 2011 | 30 |
C | 2012 | 20 |
C | 2013 | 10 |
Need a Gauge chart which will display % contribution of product over total qty in selected year.
If I select A it will give 25%... i.e. total qty of Product A / Total Qty = 50/200
If I select A and 2011 it will give 16.67% i.e. total qty of Product A in Year 2011 / Total 2011 Qty = 10/60
If I select B&C and 2013 it will give 71.42% i.e. total qty of Product B&C in Year 2013/Total 2013 Qty = 50/70
Hope my above description is clear to get an answer.
The expression should be:
Sum(QTY)/Sum({1<Year=p(Year)>}QTY))
Try: sum(QTY)/sum({<Product=>} total QTY)
See attached qvw