Create double pie table

[HitcH]

Hi

Let's make an example:

Year 2018: 3 apples, 3 bananas, 4 strawberries

Year 2019: 1 apple, 2 bananas, 2 strawberries

I'd like to create a double pie table, in 2018 table I want to see 30% apples, 30% bananas, 40% strawberries, in table 2019 I want to see 20% apple, 40% bananas, 40% strawberries.

Setting the expression is np, but I can't find how could I see both tables at the same time.

If I set year as dimension I only get a single pie with 66% 2018 and 33% 2019.

Thanks in advance for any help 🙂

[raji6763]

could you please share your screenshot and expression you used for that chart?

[HitcH]

Hi,

Attached the screenshot. I made this using alternative state (and of course this is a possible solution) but I'd like to show the two tables together.

The expressions are all different kind of discounts, so the expressions are:

=sum(disc1)/sum(invoice)

=sum(disc2)/sum(invoice)

...

[HitcH]

Is it possible to UPPPP this thread? 🙂