Jul 04 2020 07:15 PM
I don't seem to figure out how to know the number of rows in a pivot table, is there a formula for it or where to look on the table? Can someone please help me out? Thanks.
Jul 05 2020 03:55 AM
@steveo69 can you please explain in detail what you actually need with some photo attached
Jul 05 2020 04:01 AM
SolutionHi @steveo69
If i understand you correctly you need to count the row in the pivot table, you need to change the value to instead of sum to count in the value area or select the sum column > right click > summarized values by > count
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more
Jul 05 2020 09:21 AM
Jul 05 2020 11:22 PM
Hi @steveo69
Feel free to post your query & sure you can reach me along with many other experts on Tech Community to support you 8)
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more
Jul 05 2020 04:01 AM
SolutionHi @steveo69
If i understand you correctly you need to count the row in the pivot table, you need to change the value to instead of sum to count in the value area or select the sum column > right click > summarized values by > count
Regards, Faraz Shaikh | MCT, MIE, MOS Master, Excel Expert
If you find the above solution resolved your query don't forget mark as Official Answer to help the other members find it more