Three dimensions and one expression- suggest layout/chart

[#1]

Hi All,

I need suggestions for below requirement:

I have to design a chart/visible layout for frequency of purchases by product by brand by region.

Customers would like to compare performance of brand relative to product and region.

Please suggest me which chart layout is better and how it is useful

Thanks in advance,

Ramesh

[Gysbert_Wassenaar · Accepted solution]

You can try a block chart. That's one of the few charts that supports three dimensions. Or perhaps a mecko chart or grid chart, in combination with enabling the Trellis option (on the Dimensions tab).

Another thing you can try is create a calculated dimension by concatenating two of the three dimensions. For example =[Brand] & '-' & [Product]. That way you end up with two dimensions (the calculated dimension and the remaining dimension) which gives you more options for using different chart types.

[#3]

Thanks Wassenaar

I implemented block chart and it did not come up visual feed good one.. I will try Trellis (option ) - which is new and thumbs high for sharing such a useful info.