Using =MAX() or =MAXA() on Pivot results doesn't work

C

circuit_breaker

Hi,

I created a VBS file that creates a Pivot Table that looks like:

Count of ReleaseVer
ReleaseVer Total
---------------------
N/A 50
5555.5050 28630
3167.1111 2
5300.4444 6000
------------------------
Grand Total 34682

I'm trying to extract the highest "ReleaseVer" (5555.5050) in this
case. But neither max() or maxa() seems to work.

Thanks for your help
 

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

Pivot table limitations 1
Pivot Table Percentage of Sub-Total 7
LookUp on a Pivot table 1
Count values from Pivot Table 11
Sort Pivot by Year 8
Can I Sort (A-Z or Z-A) Pivot Table Data or Fields using VBA? 4
Monthly job timings analysis - automation options? 2
How to Sort by Count the Max nos of Unique text values in Pivot Ta 1

Top