1

Hi, I would like to visualise sums and counts for various categories in one table.

  1. Ie putting two pivot tables together like this:
    image
    Is it possible?
    OR
    I was thinking about
  2. using stacked bar chart for sums and then, by data label settings, display ‘count’ value on respective categories, something like this:
    image
    image611×517 10.6 KB

    Is it possible to set it somehow in data label settings?
    image
    image776×99 2.95 KB

    Thank you very much for your help,
    Best Regards,
    Katerina