Forum Discussion
To Summarize table to display into stacked chart
Hi Anonymous ,
If your table data looks like this.I don't think there is any need to add Qtr.
All you need to do is add the field to the visual and it will filter the data accordingly.
Best Regards,
Wenbin ZhouDear @Wenbin Zhou,
it's works for one of my data models 🙂
I shall look into my other to see where could go wrong then. Many thanks for your kind help, the extremely helpful tips, great enlightenment for me.
Cheers, Val
Dear WenBin,
Just for the nice idea, using the selectedValue, I manage to come close to the result, however, my result X-axis currently display ...Does that means I need to add Qtr into my dummy table - Table 2?
Q1 Current Spend Amt |
Q1 tota Projected |
Q1 Total Budget Amt |
instead of having the Q1 Grouped.... maybe due to my dataset not in Row format.... Thank you so much again for your kind advise.
| Quarter | Region | Current Spend | Projected | Budget |
| Q1 | APAC | 9000 | 10000 | 12000 |
| Q1 | EUROPE | 29000 | 31000 | 35000 |
| Q1 | US | 26000 | 29000 | 27000 |
| Q1 | LATIN | 4000 | 4000 | 4000 |
| Q2 | APAC | 13000 | 13000 | 15000 |
| Q2 | EUROPE | 35000 | 38000 | 37000 |
| Q2 | US | 22000 | 25000 | 22000 |
| Q2 | LATIN | 4000 | 5000 | 4000 |
| Q3 | APAC | 13000 | 19000 | 14000 |
| Q3 | EUROPE | 33000 | 42000 | 36000 |
| Q3 | US | 28000 | 39000 | 26000 |
| Q3 | LATIN | 7000 | 13000 | 7000 |
| Q4 | APAC | 13000 | 30000 | 17000 |
| Q4 | EUROPE | 35000 | 54000 | 40000 |
| Q4 | US | 29000 | 57000 | 32000 |
| Q4 | LATIN | 7000 | 21000 | 7000 |
Hi Anonymous ,
If your table data looks like this.I don't think there is any need to add Qtr.
All you need to do is add the field to the visual and it will filter the data accordingly.
Best Regards,
Wenbin Zhou
Dear @Wenbin Zhou,
it's works for one of my data models 🙂
I shall look into my other to see where could go wrong then. Many thanks for your kind help, the extremely helpful tips, great enlightenment for me.
Cheers, Val