Forum Discussion
Applying pivot and combining few of its columns
1. Have a dataset below, when I apply pivot I want that last three columsn get combined as in final result, is it possible? Customer Name Manufacturer Item Order Date Bill Date Amount ...
I tried similiar thing, but I got error this, can you please advise.
Attached is excel where I am working
vt_excel It seems you are using an older version of PQ that doesn't recognize the UNICHAR function.
Replace UNICHAR(10) with the following key sequence:
quotation mark, alt-Enter, quotation mark.
The measure will than look like this:
Now you can drag the measure "d" into the Values field of the Pivot table. Make sure that the part of the pivot table that holds this measure is set to Wrap Text.