It seems doable, If you can provide some sample mock up data in excel/packaged workbook then we can provide the solution.
Thank you Mahfooj,
But if I have pie charts that include the spend of all projects in company, and i divide it according to the project, is it possible to divide project piece again according to the category of spending?
How can I make only one pie chart that include main division, and by filter can be divided again according to city or project.
Thank you again.
You can add your Category field to color to divide the pies.
Follow this blog post which might help you.