2. Is it possible to use multiple FILTER USING in the same column? i.e. I want FILTER sales by Country and Category ( I cannot use general analysis FILTERS). It should be something like...
Analysis: 1 Custormer Sales xyz 100 Analysis: 2 Customer Sales Diff abc 300 200 *** Diff =Analysis2.Sales - Analysis1.Sales (300-100 = 200)
Thanks in advance.
FILETR(sales USING (country = 'INDIA') and (Category = 'SOFTWARE') )
Is it clear now? Please let me know if you need more information. Hope you will give some solution. Thanks in advance.
Prompt 1: Company ABC (Applies on Sales1 Column) Prompt 2: Company XYZ (Applies on Sales2 Column) Results: *Sales1 Sales2 Difference* 100 300 100