Firstsortedvalue and set analysis

[Jsobrinho77]

Hi guys,

I need to sum values using firstsortedvalue and set analysis with a range of dates, could you please help me?

[vinieme12]

Is this an interview Question? someone else posted the very same question

[Jsobrinho77]

First of all, thank you for your answer..

Is not an interview question, I just tried posting the question with two different users, because my first question was tagged as spam ( I don't know why )

Your first suggestion didn't work, I think the solution is using Firstsortedvalue(), please, fdo you have another suggestion?

Product	Key	Sum	Aggr	Suggestion 1
1	1|10|20|Text	558	93	558
2	2|10|20|Text2	279	93	279
3	3|10|20|Text	93	93	93
4	4|10|20|Text	0	93	0
5	5|10|20|Text	552	184	552

However, when I selected the Product with column Sum or Suggestion 1 equal 0, the result show correctly, but only when I click/filter the product.

Product	Key	Sum	Aggr	Suggestion 1
4	4|10|20|Text	186	93	186

[vinieme12]

is this sample the best representation of your actual data?

given the required output 

you can just use

Dimension = Product,Key

Measure = Sum(Qty)