Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi!
I have a table as in the example.
Is it possible to get the expected table in set analysis?
The point is that I need to create a list of products with one exclusion (days) first, and then add the sum of value (for a date) to those products without the exclusion (as in the example). All from one table.
How can this be done?
I wrote the SQL only to show what I would like to achieve the end result. I would like to do this on the front-end. I think your idea is good, but I have no idea how to adapt it.
I guess I found a solution to the problem and it was easier than expected 🙂
Dimensions:
- Days
- ProdId
Measures:
sum(
{
<
[ProdId]=p({<[Days] = {">=5"}>} [ProdId])
>
} [Value])
Thanks again for your help!