Rahul Kanadia
New Member
I have a dataset that looks like so:
I have made multiple pivots that present data as so:
I am trying to get the following result which can very easily be achieved with countifs but it would not show the filtered data like pivot does:
The activities are independent of each other.
I am working on VBA for double click and filter. Would love to know if anyone has ideas on doing this with slicers or pivots.
Unable to share the reference data since office systems are encrypted.
Please and thank you...
Title | Activity 1 | Activity 2 | Activity 3 |
T1 | 91 | 87 | 60 |
T2 | 8 | 35 | 80 |
I have made multiple pivots that present data as so:
Activity 1 | T1 | T2 |
0 - 10 | 1 | |
11 - 20 | ||
21 - 30 | ||
31 - 40 | ||
41 - 50 | ||
51 - 60 | ||
61 - 70 | ||
71 - 80 | ||
81 - 90 | ||
91 - 100 | 1 |
I am trying to get the following result which can very easily be achieved with countifs but it would not show the filtered data like pivot does:
T1 | T1 | T1 | T2 | T2 | T2 | |
Value Group | Activity 1 | Activity 2 | Activity 3 | Activity 1 | Activity 2 | Activity 3 |
0 - 10 | 1 | |||||
11 - 20 | ||||||
21 - 30 | ||||||
31 - 40 | 1 | |||||
41 - 50 | ||||||
51 - 60 | 1 | |||||
61 - 70 | ||||||
71 - 80 | 1 | |||||
81 - 90 | 1 | |||||
91 - 100 | 1 |
The activities are independent of each other.
I am working on VBA for double click and filter. Would love to know if anyone has ideas on doing this with slicers or pivots.
Unable to share the reference data since office systems are encrypted.
Please and thank you...