The attached file has a pivot based on a small sample of data, I'm working on. I have created the Calculated Field "THROUGHPUT", which is basically "SALES" divided by "Count of ASSET TYPE". On the DATA worksheet one can see the "ASSET TYPE" contains all Texts.
Is there any way to divide a Number Field (in this case it's "SALES" column) by the Count of a Text Field (it's ASSET TYPE Column)?
Thanks for any help. Regards.
Bookmarks