Hi All,
I am having a scenario in crosstab report.
_____ 2011 _______
___Jan____Feb ___March__
PL1 1000 5000 8000
20/40 30/40 69/80
PL2 8000
45/80
PL3
In above scenario, Values PL1 is from productline.
2011 is from Year column
Months from Month column
1000 is from qty column
(20/40) here 20 is unit price and 40 is unit sale price, and (/) is a seperater.
I did by unlocking xtab, and added a table of 1 col and 2 rows, In 1st col dragged the qty, and in other added unit price and unit sale price
The issue is qty is coming properly, while other measure columns are showing repeated data.
Thanks