This content has been marked as final. Show 6 replies
The following is the pivot table that I've generated which contains only two rows of sales.
I tried to add a third row to display the ratio of the sale, say $54,508.35/$38,874.04-1 which will give me 40.22%. If possible, it will ideally showing as following. (I've made the following pictures from EXCEL.)
But other than showing the Total of the sale, couldn't figure how
1. how to add this extra row
2. how to put the calculated values.