Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
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
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
Thanks Prashant. Such a simple workaround... guess I went nuts after hours of trying to solve it at the value columns.