Crosstab with replicate rows

building reports webintelligence
1

Hi,

for below data

vendor—product–period—Qty–price
ABC------123------2020 01–10—100
ABC------123------2020 02 --20—200
ABC------123------2020 03—5----50

When cross table is created, showing three different lines

QTY and Price is measure, others are dimensions

Vendor–part------------------period
-------------------------------2020 01--------------2020 02---------2020 03
ABC------123----------------10 -----100---------------------------------------
ABC------123-------------------------------------20-----200---------------------
ABC------123----------------------------------------------------------5-----50

I want everything in one line
Vendor–part------------------period
-------------------------------2020 01--------------2020 02---------2020 03
ABC------123----------------10 -----100----------20-----200-------5-----50

please, Any suggestion

thanks in advance

ThanksForHelp (BOB member since 2006-09-25)

2

One of the measure was Dimension in the Universe, after changing to measure it didn’t work. So deleted the report table and re-created. It worked fine.

thanks

ThanksForHelp (BOB member since 2006-09-25)