Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Check enclosed file..
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
Like this?
Check the attachment.
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.
Try below also...
and let me know whether this is what you are looking after?
SUM({<YearMonth = {'<=$(=Max(YearMonth))'}>}Sales)