HI folks, I am using a pivot table with below attributes - Country,Currency,[Other Lines] and measure - [Amount]
Everything is now simple. I have a requirement to add 3 static lines after each currency (let's say Line1/2/3) which calculate second measure and it doesnt have split across next dim i.e. [Other Lines]
Now i tried to add it as new dim using ValueList and calculate value, but issue that all values [Other lines} is now coming under each of these static lines 1,2,3. Which is obvious behaviour of pivot table. I need output like below -
United States |
USD |
Line1 |
Line2 |
Line3 |
Other Lines |
UAE |
Dirhams |
Line1 |
Line2 |
Line3 |
Other Lines |
Values Line1,2,3 should NOT be expanded and no dimension should come under those lines. Hope I was able to put requirement clearly. Any help would be much appreciated guys.
TIA.