By creating a calculated field similar to the following the above can be done:
"$" +str(round(sum((Sales)),2)) + " (" + str(round(avg((Discount)*100),2) ) + "%)"
Note, the calculation may need to be edited slightly to get the correct formatting.
Hope this helps!
I able to follow what you have suggested. now I need to have the same calculated fields by Period.
Something like this
For 2011 = $1,500 (50%)
For 2012 = $1,500 (50%)
Would it be possible?
This should be possible. I'd have to see the workbook so that I could give more appropriate instructions for your scenario. However, most likely a table calculation would be used in there somewhere.