Month Selection not working

[kushalthakral]

Dear All

i have data for two months

when ever i select Jan or Feb it showing correct results but when i select both month it is showing different result not month wise

say i have

Model  Month     Sales

A          Jan          100

B          Jan          20

A          Feb          200

B          Feb          40

When ever i select Jan it shows A 100 and B 20 and for Feb it shows A 200 and B 40

But i waana show it like

Model	Jan	Feb	March
A	100	200
B	20	40

But i m getting wrong result in this

Thanks

Kushal Thakral

[MK_QSL]

Check enclosed file..

[kushalthakral]

Dear Manish

You have written two different folrmulaes for Jan and Feb month

But i want to automate this process

means every month new column added and figures shows there

Regards

Kushal

[MK_QSL]

Like this?

[#5]

Check the attachment.

[#6]

You could just put it in a pivot table with 2 dimensions (Model followed by Month)  and sum(Sales) as the expression. Once the table is populated you can drag it on top of the expression and view as many months as required.

[MK_QSL]

Try below also...

and let me know whether this is what you are looking after?

SUM({<YearMonth = {'<=$(=Max(YearMonth))'}>}Sales)