Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys,
I need to sum values using firstsortedvalue and set analysis with a range of dates, could you please help me?
Is this an interview Question? someone else posted the very same question
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 |
is this sample the best representation of your actual data?
given the required output
you can just use
Dimension = Product,Key
Measure = Sum(Qty)