How to add field CUST_ID into my existing Payment Pivot Table ?

[paulyeo11]

Hi All

I have a pivot table 1 WORKING FINE  , i need to add one more field CUST_ID at first column.

By right i should add CUST_ID at Dimension.

After Add it , i get every row with total . ( See my Table 2 )

Hope some one can help me.

Paul

[paulyeo11]

my QVW

[sunny_talwar · Accepted solution]

Uncheck 'Show Partial Sums' for COMPANY_PAY dimension and add it for CUST_ID

[paulyeo11]

Hi Sunny

Thank you very much,.it work fine now.

Paul