how do i display some extra text information in pivot table data area

S

shripaldalal

hi,

my pivot table is ready and working fine, something like this:

group1 group2 ledgerac
opnbal debit credit
group1
group2

ledger 100
200 300

i want something like this:

group1 group2 ledgerac
opnbal debit credit
group1
group2

ledger 100 Dr
200 300

OR

group1 group2 ledgerac
opnbal debit credit
group1
group2

ledger 100 Cr
200 300

i dont think using a calculated field would work ? can this be done ?

regards,
shripal dalal.
 
M

Mike Fogleman

You could apply a Custom Format to the cells...
?" Cr" would result in 100 Cr

Mike F
 
S

shripaldalal

You could apply a Custom Format to the cells...
?"Cr" would result in 100Cr

Mike F
Click to expand...

mike,

thanks a million, it worked like a charm.

best regards,
shripal.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Adding columns in pivot tables 4
how do i show extra information in data area of pivot table 1
help with pivot table required 0
How to add a percentage column in a Pivot Table 1
Calculated Item causes undue repitition in pivot table 2
pivot table help 0
How do you group data in a Pivot Table? 1
Pivot table to calculate variance showing budget and actual. 3

Top