If you are unable to create a new account, please email support@bspsoftware.com

 

Data values gets repeated when adding multiple measure col inside crosstab

Started by saumil287, 05 Jul 2019 04:18:38 AM

Previous topic - Next topic

saumil287

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