I have been asked to do a pie chart based on two dimensions (let us say Zone and Item) combined together. This means, they don't want to see a two level pie, as like QV will do in this case, but a plain pie with the two dimensions combined together. Like this:
ZONE1 - ITEM1 is a slice ZONE1 - ITEM2 is another slice ZONE2 - ITEM1 is a third slice, and so on...
In other word, this would be the same we would get in the external crown of a two-dimension pie, but without the internal sub-pie.
The solution should be a calculated dimension like that:
Zone & "-" & Item
But this seems to be very hard to compute for QV and, eventually, I get an out of memory or internally failed drawing error, despite the numerosity of the fields is rather low (the total number of combination is about 20). Using a linear table instead, I get the result without errors, after a very long computing time.
So, I managed to give them their pie with concatenated dimensions, but removing any other object and data... and still it takes minutes to draw. Definitely it's a critical task for QV.
Yes, I can, and I agree this is the best solution. I was trying to avoid it because, besides the example, I have a number of different combinations to consider, but I will do this way.
