Using 2 aggregate functions

[harveenkaur]

Hi

I want to count cities having sum(Quantity)>1000 and sum(Sales)>1200 for the maximum month year in Date( In sample Data :- Sept. 2018)

City	Quantity	Sales(Rs)	Date
C1	1000	2000	12-Sep-18
C2	12312	12310	13-Sep-18
C3	121	21223	12-May-18
C4	1212	1313	30-Aug-17
C1	1212	12123	20-Sep-18
C2	121	1313	08-Nov-18
C3	121	132	09-Nov-17

[PradeepReddy]

Create a calculated field in script like this...
Load *,
Date(monthstart(Date#(Date,'DD-MMM-YY')),'YYYY-MMM') as YearMonth
From TableName;

Create straight table, with
dimension : YearMonth
expression: Count(Distinct {<Quantity={'>=1000'},[Sales(Rs)]={'>1200'}>}City)

[harveenkaur]

I have YearMonth field but don't want to use it as dimension.
I want it to be included in the expression
expression: Count(Distinct {<Quantity={'>=1000'},[Sales(Rs)]={'>1200'}>}City)

[PradeepReddy]

can you post the sample output, from the data you provided earlier?

[harveenkaur]

Output will have:-

City

C1

C2

I want only City as Field.