Dear All,
I have a simple spreadsheet where I made a PIVOT from.
I sorted my list by "Identifier", and then in the pivot summed up/averaged values which have the same identifier (Limit, %, USA, Germany).
However, in column "PM No." and "Currency" in the PIVOT I would like to see the text, after all, per one identifier these values are always identical. But I could not find a solution in the internet.
Is that possible in PIVOT? In total I would probably have four text fields, always identical text per identifier. I would like to prevent any coding/programming.
many thanks and kind regards,
Sandra
Identifier No. Amount % of X Currency USA Germany
AAA421 a101 15,000 5% USD 15,000
AAA421 a101 20,000 5% USD 20,000
AAA421 a101 10,000 5% USD 10,000
BBBCAI b102 5,000 4% EUR 5,000
BBBCAI b102 10,000 4% EUR 10,000
BB1111 b402 5,000 6% USD 5,000 5,000
BB1111 b402 4,000 6% USD 4,000 4,000
BB1111 b402 3,500 6% USD 3,500 3,500
BB1111 b402 2,500 6% USD 2,500 2,500
Bookmarks