This post is something similar to one I posted a while ago.
My user has asked me to try and produce something similar to the attached excel file.
My data source is a transactional sales invoice qvd database.
Replicating columns A, B, C and D is very straightforward.
"Region" and "FY" (Financial Year) are dimensions with Sales, Gross Profit and GM% being expressions.
The problem comes when I try to add columns E and F.
These will be expresssions with the logical place for the pivot to add them being below Sales, Gross Profit and GM%.
As I previously stated, I did have a similar issue which i posted on the forum - this was solved by creating a summary table - was just interested in seeing if there was another solution to this issue.
