How to split the expression based on some condition?

[#1]

Dear Experts,

Our current Chart designed as below.

Dimension : 12 Customers (X-Axis)

Expression : Total sales amount for the last 3 years (Y-Axis)

But our exact requirement is to split the expression by showing 3 individual year total sales for each customer. So that we can see the trend easily.

Kindly advise.

Thanks,

Saravanan

[#2]

[swuehl · Accepted solution]

Maybe just use a second dimension Year in your chart?

And then choose either stacked or grouped style on style tab?

[HirisH_V7]

Hi,

Make Year as your First Dimension and Customer as second Dimension Like this,

HTH,

Hirish

[Kushal_Chawda]

like this?