Guage Chart

[MK_QSL]

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.

[#2 · Accepted solution]

The expression should be:

Sum(QTY)/Sum({1<Year=p(Year)>}QTY))

[Gysbert_Wassenaar]

Try: sum(QTY)/sum({<Product=>} total QTY)

See attached qvw