Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Everyone,
I wish to achieve something depicted in the above picture.
The dimension on the left can be removed/added based on user selection through dynamic table field selection, so Dimensionality will keep changing.
I am facing issue in introducing the Achievement column highlighted in yellow. Achievment = Sales of 12 months/Goals of 12 months.
Can I insert an expression like this in pivot table? If I use a straight table, I cannot have pivoted headers for sales and goals.
Please help.
gwassenaar