Qlik Sense pivot table - split data by distinct unit price?

[user467341]

Hi all,

I created a pivot table to find the total price for materials, based on customer and model. This works well but I found an issue when there are cases where same material may have two different unit prices, and this result in pivot table showing '-'. See below for an example,

You can see that John, Mat_ID 6534 unit price is '-' because there are two unit prices. Same goes for Janice.

I need the pivot table to split this up, the EXPECTED OUTPUT will be like this

Where you can see the yellow part the same Mat_ID has been split into the two different unit price.

I can't seem to figure out this. Appreciate for advice!

[PrashantSangle · Accepted solution]

when you use any aggregation functions and if you don't have any unique column (or combination of multiple column) then it will combine it into one value. 

So, as a work around add that qty field as dimension then try.

Regards,

Prashant Sangle

[user467341]

Thanks Prashant. Such a simple workaround... guess I went nuts after hours of trying to solve it at the value columns.