Trellis Chart

[Anonymous]

Hi All,

I got a requirement to create chart as in the attached document.

Need to create something a kind of trellis chart. But I am not sure on how to achieve this.

Kindly help me in creating this chart by sharing your thoughts & ideas.

Thanks a lot in advance

[Gysbert_Wassenaar]

You can't do this with a trellis option. Pivot tables and straight tables don't have a trellis option. You'll have to create a separate chart object for each table if you want that kind of layout. Personally I'd use the currency field as dimension in a pivot table.

[Anonymous]

Thanks Gysbert.

Actually I have to use 3 dimensions and an expression.

The dimensions are Company, Currency & Category. The expression is Amount.

First the chart should categorize on Company inside company based on currency and in that category something like that I have to create.

Company

     -> Currency

               -> Category = Expression

Whether we can do this in straight table??

If you have any idea on this please share