Is this possible with p()?

[john_oll]

Product:

LOAD * INLINE [

    Product, FinishedProduct

    111, 411

    411, 411

    112, 412

    412, 412

];

ProductSales:

LOAD * INLINE [

    Product, Customer, Sales

    411, Miller, 20

    411, Miller, 30

    412, Smith, 100

];

With this data, I would like to accomplish the following result (without using applymap etc. in the script):

I think this should be possible with p() or standard set analysis.

My best guess is
sum( {< Product = P( FinishedProduct)  >}  Sales)

but this did not work.
Is this possible with p()?

[marcus_sommer · Accepted solution]

No, this isn't possible with p() or e() because they are related to the (not) possible values from a global point of view and not on a dimension-level.

Beside this I'm not sure that your association of the tables per Product is suitable or if it shouldn't be better on FisnishedProduct? Is there any tag available to differ between Product and RawProduct?

- Marcus