Guage Chart

MK_QSL — Thu, 22 Aug 2013 09:49:00 GMT

Hi Community,

I have below table.

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.

Re: Guage Chart

Thu, 22 Aug 2013 10:04:55 GMT

The expression should be:

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

Gysbert_Wassenaar — Thu, 22 Aug 2013 10:17:54 GMT

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

See attached qvw