P() Possible Function in Set Analysis Understanding

[erric3210]

Hi Community,

Can anyone please explain me how P() function works inside Set Analysis.

The table I'm using:

In 1st Expression I've used used minimum Date and used Distinct Dates. If you see, it is calculating minimum Date  but it is showing all dates available in the data. It should give output only for '44582'.

The 2nd expression is same as 1st expression, the only difference is that I've used Distinct Item_Name here instead of Distinct Dates and this expression is giving me correct result.

Can someone please explain me how it calculating the expression internally.

Regards,

Eric

[Lisa_P]

Let me illustrate the concept ..

Imagine you had a filter pane and selected a product (AAA Running Shoes), you would see that there are a number of possible customers who purchased those running shoes. The total sales of running shoes is 185.6k. But if you look at the total sales of all customers who purchased those shoes, the value is 18.63M.