Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello everyone,
a client share his file in the format like below,and he wants all his KPIs which he shared in Quarter,month and year vise.Iam not able to understand how I find quarter,month and year from the table.I applied crosstable but it wont work.please anyone has any idea share with me.Its urgent.
Dimension | Sum of Q1 | Sum of Q2 | Sum of Q3 | Sum of Q4 | Year 2012-13 |
---|---|---|---|---|---|
Cost | 200 | 410 | 110 | 200 | 920 |
Expense | 100 | 120 | 130 | 100 | 450 |
Rent | 200 | 100 | 100 | 100 | 500 |
Tax | 400 | 100 | 200 | 300 | 1000 |
now requirement is to show tax quarter,month and year vise.But how to create quarter,month and year from above shared data.
Attached is an example on how to approach this. You can't do at month level because the data provided is aggregated at Quarter level.If Q1 is July, Aug, Sep and its cost is 200 how would you know whats the split for those three individual months.
Please check with the users on that.
Thanks
You can use the jerarquico group
I attached a example
Attached is an example on how to approach this. You can't do at month level because the data provided is aggregated at Quarter level.If Q1 is July, Aug, Sep and its cost is 200 how would you know whats the split for those three individual months.
Please check with the users on that.
Thanks