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.
