Create a pivot

[kop1ko]

Hello,

In my attached file, i just want to make a pivot of "PV Report" like format in PV-Correction Summary.

Please help.

[cbatrody]

Hi,

See the attached file.

[kop1ko]

Hi cbat,

That's what I need! thank you so much!
Could you please help how do you it specially in the

Please Login or Register  to view this content.

I can't get the Columns and Values fields just what you do.

[cbatrody]

Hi,

$ Impact - Sum of "Amount"

Total PV - Week - Count of "Week"

% of Passed / Failed PV - Again Count of "Week" with modified "Field Settings" as following:

Right click on the last column -> "Value Field Settings"

[kop1ko]

got it thanks!