Is it possible in the pivot table feature to find the grand total of N number of rows. For example, I want to find the grand total for the top 25 rows but it's giving me the grand total of every single row available.
I think it is currently impossible to retrieve the top 5 rows of the total. However, you can try filtering the top 25 by a specific dimension, and then summing them up as the total.
User | Count |
---|---|
3 | |
2 | |
1 | |
1 | |
1 |