P
pamarty
Hi,
I need to create a pivot table from raw data that has one of the
columns as percentage
C1 C2 C3 C4 C5 Percentage
AAA XXX FFF G1 6778 0.045
AAA XXX FFF G1 6778 0.050
AAA XXX FFF G2 6778 0.052
AAA XXX FFF G2 6778 0.066
AAA XXX FFF G3 6778 0.080
AAA XXX NNN G1 6778 0.045
AAA XXX NNN G2 6778 0.070
BBB YYY CCC G4 6778 0.045
The pivot table that I need to create should display values for G1, G2
etc based on percentages ranges as:
C1
--ïƒ C2
-ïƒ C3
ïƒ C4
ïƒ percentage < 5%
ïƒ percentage = 5%
ïƒ percentage > 5%
I tried to use grouping for the percentage field but it does not work.
I am new to pivot tables. Any help will be greatly appreciated.
Thanks,
pamarty
I need to create a pivot table from raw data that has one of the
columns as percentage
C1 C2 C3 C4 C5 Percentage
AAA XXX FFF G1 6778 0.045
AAA XXX FFF G1 6778 0.050
AAA XXX FFF G2 6778 0.052
AAA XXX FFF G2 6778 0.066
AAA XXX FFF G3 6778 0.080
AAA XXX NNN G1 6778 0.045
AAA XXX NNN G2 6778 0.070
BBB YYY CCC G4 6778 0.045
The pivot table that I need to create should display values for G1, G2
etc based on percentages ranges as:
C1
--ïƒ C2
-ïƒ C3
ïƒ C4
ïƒ percentage < 5%
ïƒ percentage = 5%
ïƒ percentage > 5%
I tried to use grouping for the percentage field but it does not work.
I am new to pivot tables. Any help will be greatly appreciated.
Thanks,
pamarty