How to extract date when sales value reach exactly 100k?

[anindya_manna]

Hello Experts,

I am creating a chart with the columns id ,name ,sales,100K break date.I want to show id and names whose sells more than or equal to 100k and also the aook break date in which it exactly touch 100k milestone.

How to do it in a single table?

[anindya_manna]

See its not working

[anindya_manna]

Data.Assume sales limit by 1000

[YoussefBelloum]

only({<Id={"=aggr(sum([Sales Amount]),Id,Name,[Process Date])=THE VALUE YOU WANT"}>}[Process Date])

[anindya_manna]

PFA

Its not working.

[anindya_manna]

Nope.Can you please check the qvw I attached?

[anindya_manna]

PFA

[YoussefBelloum]

the solution above on the QVW attached..

maybe I'm missing something ?

you want to display on a column the dates with SUM(Measure)>= a value ?

[anindya_manna]

This is my Test Data

Id	Name	Process Date	Sales Amount
1	xxx	1/1/2018	200
1	xxx	1/2/2018	200
1	xxx	1/3/2018	200
1	xxx	1/4/2018	200
1	xxx	1/5/2018	200
1	xxx	1/6/2018	200
1	xxx	1/7/2018	200
2	YYY	1/1/2018	300
2	YYY	1/2/2018	300
2	YYY	1/3/2018	300
2	YYY	1/4/2018	300
2	YYY	1/5/2018	300
2	YYY	1/6/2018	300
2	YYY	1/7/2018	300

I want to display this

Id	Name	Sales Amount	Break Date
1	xxx	1400	1/5/2018
2	YYY	2100	1/4/2018

Please find the attached QVW and plese help me to get exact code.

[jyothish8807]

try this:

I have taken 1000 as bench mark.

Br,

KC

[sasiparupudi1]

Try this

rangesum(Above(Sum([Sales Amount]),1,NoOfRows(TOTAL)))

If(rangesum(Above(Sum([Sales Amount]),1,NoOfRows(TOTAL)))=1000,[Process Date])