Showing 2 main columns in a pivot table

[Anonymous]

I have a pivot table showing invoiced values by stock code, i want to also show as default the customers part no when applicable.  it obviously shows when you drop it down from the stock code, but i want it to constantly show... help?  its a shame you cant print screen on here to show exactly what im trying to say...(see attachment)

[danieloberbilli]

go on object properties, presentation tab, check Always fully expand

[kiranmanoharrode]

Try Aggr() Function,

=Sum(AGGR(Sum(NetSalesValue),StockCode,Cus_part_no))

=Sum(AGGR(Sum(QtyInvoiced),StockCode,Cus_part_no))

Regards
Kiran Rode

+91 8976977897

[Anonymous]

Yes i had already done that but it showed everything. I have now sorted it though, thank you both for your help