Hello friends, hope all is well.
Please open the attachment, and if you please help me with the pivottable.
I want to divide the results of RV over the Visits.
I can’t find the way.
Really appreciate it in advance
Hello friends, hope all is well.
Please open the attachment, and if you please help me with the pivottable.
I want to divide the results of RV over the Visits.
I can’t find the way.
Really appreciate it in advance
You can only do it for the whole field, not just parts of it.
One possibility might be to create auxiliary columns, one for REV and other for Visits, use them in the pivot table, and with that you can do a calculated field.
The other option, is simply to have that above the pivot table: =D16/D17.
Hope it helps
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks