topic Re: In Table other Company Data is not getting. in App Development

In Table other Company Data is not getting.

sachin1 — Fri, 15 Nov 2024 20:52:40 GMT

I have the fields 'Company,' 'Region,' and 'Sales,' and I want the output which field is in bold.

Kushal_Chawda — Wed, 04 Sep 2024 12:50:04 GMT

@sachin1 try below

Data:
LOAD Company,
Region,
Sales
FROM table;

Left Join(Data)
Load
Region,
sum(Sales) as [Company A Sales]
Resident Data
where Company='A'
Group by Region;

Final:
NoConcatenate
Load *,
Sales- [Company A Sales] as [Sales - Company A Sales]
Resident Data;

Drop Table Data;

madelonjansen — Wed, 04 Sep 2024 14:37:58 GMT

I think you could do it with Set Analysis:

Company "A" Sales: Sum({<Company={A}>} TOTAL <Region> Sales)