Hi All,
Can Anybody help me out in this issue,
I am using one Stacked bar chart to do analysis of product.
I am taking 'year' and 'Product_category' as dimension and 'count of product in percentage' (Count of each product/Count of all the product)as expression . For that I am using the following Expression.
count( distinct if ( Volume > 0, Product))/count({$<Product=>} total distinct if ( Volume > 0, Product))
It shows 100% in chart If I select a particular year. But If I see for all the years, its taking "Count of each product / Count of product for all the year". I need an expression like, If we not select any particular year also it should count each product and do division for that particular year.
For eg:
| Year | Product Category | Product in % | Count | I need like |
| 2005 | A | 0% | 0 | 0 |
| 2005 | B | 1% | 2 | 1.503759 |
| 2005 | C | 0% | 1 | 0.75188 |
| 2005 | D | 12% | 38 | 28.57143 |
| 2005 | E | 1% | 4 | 3.007519 |
| 2005 | F | 14% | 43 | 32.33083 |
| 2005 | G | 15% | 45 | 33.83459 |
| 2005 | Total | 43% | 133 | 100% |
| 2006 | A | 0% | 0 | 0 |
| 2006 | B | 2% | 5 | 2.777778 |
| 2006 | C | 0% | 1 | 0.555556 |
| 2006 | D | 16% | 49 | 27.22222 |
| 2006 | E | 2% | 5 | 2.777778 |
| 2006 | F | 16% | 49 | 27.22222 |
| 2006 | G | 23% | 71 | 39.44444 |
| 2006 | Total | 58% | 180 | 100% |
| 2007 | A | 0% | 1 | |
| 2007 | B | 2% | 6 | |
| 2007 | C | 0% | 1 | |
| 2007 | D | 14% | 43 | |
| 2007 | E | 3% | 9 | |
| 2007 | F | 15% | 48 | |
| 2007 | G | 30% | 92 | |
| 2007 | Total | 65% | 200 | |
| 2008 | A | 0% | 1 | |
| 2008 | B | 0% | 1 | |
| 2008 | C | 0% | 0 | |
| 2008 | D | 6% | 18 | |
| 2008 | E | 5% | 15 | |
| 2008 | F | 1% | 4 | |
| 2008 | G | 20% | 61 | |
| 2008 | Total | 32% | 100 | |
| 2009 | A | 0% | 0 | |
| 2009 | B | 0% | 0 | |
| 2009 | C | 0% | 0 | |
| 2009 | D | 15% | 45 | |
| 2009 | E | 4% | 13 | |
| 2009 | F | 0% | 0 | |
| 2009 | G | 11% | 34 | |
| 2009 | Total | 30% | 92 | |
| 2010 | A | 0% | 0 | |
| 2010 | B | 0% | 0 | |
| 2010 | C | 0% | 0 | |
| 2010 | D | 13% | 40 | |
| 2010 | E | 1% | 3 | |
| 2010 | F | 0% | 0 | |
| 2010 | G | 1% | 3 | |
| 2010 | Total | 15% | 46 | |
| Total | | 100% | Products: 310 | |
If I am not selecting any particular year also, It should show me the 100% value for the products.
Please reply me soon,
Thanks in Advance!
Kirthi
