how do i show extra information in data area of pivot table

S

shripaldalal

hi,

have a pivot table up and running fine. just one question.....in the
data area i have four fields....

opn bal, debit, credit

the operation is sum on all the fields......

the only question is in opn bal...if there is a value 100, i want to
have some field next to it that says "dr" or "cr".......so something
like 100 DR or 100 CR.....

i cannot use calculated fields because it's a text field and i cannot
perform some mathematical function on it.....

please let me know if there is some way around it.....

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

how do i display some extra text information in pivot table data area 2
monthly opening and closing balance in pivot table 4
Sum in Pivot Table 1
Pivot Table - Using If Then logic 2
Get visible pivot table items 4
Pivot Table Field based on two data area fields 3
Pivot Table Deconstruction 2
selecting cells to produce a pivot table 4

Top