Need help to get the expression?

[#1]

Hi Qlikheads,

Can anyone help me to get the below scenario,

Scenario:  I Have UID, KPI ID,KPI, Period Wise Sales(Cross table) ,I want the Sum(Sales) of UID for Count(Product_Developed)  Goes down and sum(sales) Remain same for my Current period compared to previous period

Sample data attached.

Thanks

John

[Gysbert_Wassenaar]

See attached example.

[Anonymous]

PFA the solution

[#4]

Hi Gysbert Wassenaar,

Thank you for quick response, I have changed my problem little bit please help me on that.

Thanks

John

[Gysbert_Wassenaar]

Can you translate your requirements in simple english for me? I don't understand them. An example with numbers would be helpful.