Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
can any one pls help me how to achieve this
Hi,
You could combine valueList with dual to make that. I made an example, you just need to change the dimension and the expressions sum's for those you want to use.
Yes you could achieve multiple lines with the Pivot Table. You will have to have a multilevel dimension that will represent the multirow header. In the example I included I have made it artificially by an inline table but this could come from any source also and be connected of course to your data values/measures/metrics:
Hi,
You could combine valueList with dual to make that. I made an example, you just need to change the dimension and the expressions sum's for those you want to use.
Thanks for your reply petter.
But my data is in excel format. can u please help me in this
Do you have an Excel sheet with your data that you could upload - or a representative sample?
Hi Petter,
See below image,
2nd column i.e May fall under CURRENT field
Overall, April and Monthly% fall under YTD actuals,
and May, April and Trend% fall under Soverign Actuals.
Please help
Thanks in advance..
I was thinking about a real XLSX-file - so I dont need to spend time to make test data that you might have already...
can u give your mail id please i will send it to your mail