Pivot Table calculated field - expression syntax request

[Anonymous]

Hello,

May i have some help on this.  

growth

I have the following data set (blue) and i need to create a Pivot Table report as shown in the bottom Table (green).

I have seen a lot of examples but I have not yet found the syntax I need to build the growth expression.

Thanks in advance for your help.

[Anil_Babu_Samineni]

Please post data in excel/text format instead image? But, I don't think in your example there is anything tough. Try

Dimension is Month

And, Expressions are

Sellin - Sum({<Status = {"Sellin"}>} Measure)

Sellin - Sum({<Status = {"Sellout"}>} Measure)

[Anonymous]

Hello Anil, thanks for your answer.

Attached the excel table.

I tried your code in a Pivot Table as shown in the attached screenshots but data is not displayed.

this is the script

LOAD Status,

     Product,

     [Stock Number],

     Month,

     Sales,

     Units

FROM

(ooxml, embedded labels, table is Sheet1);

[Anil_Babu_Samineni · Accepted solution]

two measure should be

Sum({<Status = {"Sellin"}>} Sales)

Sum({<Status = {"Sellout"}>} Sales)