Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

To Summarize table to display into stacked chart

Hi , I have been struggling ....I have my data with sum of total for all the stages :  1) Current Spend 2) Project 3) Budget and I hope to stack by region (2nd image) and , i could do it in exce...
Need Help
Tips and Tricks
  • Anonymous's avatar
    Anonymous
    2 years ago

    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

  • Anonymous's avatar
    Anonymous
    2 years ago

    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 

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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