Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
I have a table chart in frontend which containg data as below
Business | Month | Sales |
Direct | Apr | 100 |
Direct | May | 200 |
Direct | Jun | 300 |
Direct | Jul | 400 |
Direct | Aug | 500 |
Indirect | Apr | 10 |
Indirect | May | 20 |
Indirect | Jun | 30 |
Indirect | Jul | 40 |
Indirect | Aug | 50 |
I want to subtract Business=Indirect value for month of Apr from Business=Direct and show in a separate table chart.
(here for Apr = 100 - 10). Similar for all months
Desired output:
Business | Month | Sales |
Net | Apr | 90 |
Net | May | 180 |
Net | Jun | 270 |
Net | Jul | 360 |
Net | Aug | 450 |
Regards,
Aditya
Try
Sum(Aggr(Sum({<Business={'Direct'}>}Sales),Month))- Sum(Aggr(Sum({<Business={'Indirect'}>}Sales),Month))