unknownymous
Board Regular
- Joined
- Sep 19, 2017
- Messages
- 249
- Office Version
- 2016
- Platform
- Windows
Hello Gurus,
Hope you had a nice weekend.
I was trying to find a way on how to show the "Count of Indicator" but can't figured it out on Pivot. I was thinking that if it won't work on Pivot maybe IF formula or VBA would be helpful .
Raw
Result
Any thoughts will much appreciated.
Hope you had a nice weekend.
I was trying to find a way on how to show the "Count of Indicator" but can't figured it out on Pivot. I was thinking that if it won't work on Pivot maybe IF formula or VBA would be helpful .
Raw
| Account | Country | Data | Score | Indicator (value after summing the data) |
| 1 | France | Europe | 500 | Positive |
| 2 | Spain | Europe | 250 | Positive |
| 1 | France | Europe | -100 | Positive |
| 1 | France | Europe | -50 | Positive |
Result
| Data | Count of Indicator | Sum of Score |
| France | 1 | 350 |
| Spain | 1 | 250 |
Any thoughts will much appreciated.
