Two dimensions and two measures in a chart

[#1]

Hello,

I am developing a requirement.

I have 2 dimensions:1.Month

2.Expense Head

I have two measures 1. CY Expense

2. PY Expense

I have represented that in scatter chart

But the presentation is looking confusing as the month wise distribution is only coming on mouse point. Please help out.

[sasikanth]

HI,

Try add Month and Expence Head into Cyclic Group ,

[millan123]

Hello,

You can use the combo chart that will be good or use cyclic group for same chart

[Anonymous]

Hi Debasmita,

With two dims and two expressions, it will be confusing.

You can do it with trellis, to represent one chart for each Expense Head.

Other option is using a pivot table.

Regards!