Using where condition in an Expression of chart

[raghavsurya]

Hi,

I have a table named Revenue. The columns in the table are Particulars, Month and Amount. I am trying to create a straight table chart where in I need the amount for each month to be shown in different column.

Particulars

Jan

Feb

Mar

Apr

May

Jun

Jul

Sales xxx xxx

In order to do this, I should put a where condition in the expression to pick amount where month = 'Jan' and so on. I have tried putting the below condition.

num (if (Month = 'Jan',sum(Amount)))

but this is not returning any value. Can somebody pls help.

Thanks and Regards,

Raghav

[sparur]

hello,

what about pivot table?

you can to move Month dimension on the top and crate cross table 🙂

[sparur]

please, see in my example

[raghavsurya]

Thanks Anatoly... it helped.

Regards,

Raghav