Hi All,
I got a new requirement from my client, they want sales report in a tabler representation based on the geo(dimension) and product wise.
Please find the attachment, it is showing the metrics will comes under the perticular column names in the report.
I know that we can give the metrics based on the perticular products or dimensions.but my question is, how can we represent the product-1.
And we can see the product-1 it is having 5 categories Jul'12,YTD Ju'12,Jul'11,Dec'11 and growth% over and again i have3 categories in Jul'12 and YTD Jul'12.
How can we represent this in qlikview,can anyone having the idea about this.
| Product-1 |
| Jul'12 | YTD Jul'12 |
|
| Growth % Over |
| Sales | Target | % Ach | Sales | Target | % Ach | Jul'11 | Dec'11 | Average | YTD |
regards,
baru
