I have data in the below format wherein 2 pie charts needs to be created based on the selection (Here it is Global/Local field). Pie chart needs to show applications only that belongs to either global or local.
APM ID
Application
L1 Process
Global / Local
Sub Portfolio Level B
Application Lifecycle Phase
Budget
Budget 2017
Key
FRB
SK
UDT
Status
176
Impact
DCL
Global
Service & Repair
XXXXX
2863.929
2863929
0.129
17570000
0.132
2319240
4. Confirmed with UDT (100%)
176
Impact
DCL
Local
Service & Repair
XXXXX
2863.929
2863929
0.129
17570000
0.132
2319240
4. Confirmed with UDT (100%)
Please let me know expression for set analysis and also where we have to incorporate the same
