Product of n values

[Anonymous]

Want to calculate something like this where T1,T2...Tn are the values from 'Timekey' dimension selected by the user

((1+Sum({<Timekey={'T1'}>}Sales)) * (1+Sum({<Timekey={'T2'}>}Sales)) * ....) - 1

How to achieve this ??

Message was edited by: Sayyam Bhandari

[sunny_talwar]

Would you be able to share a sample to see what you have and what you expect to get?

[Anonymous]

Hi  Sunny Talwar

I have uploaded a sample qvf. Can you please have a look at it and suggest some solution.

[Anonymous]

you can see the same question i asked here but didnt get satisfactory answer

I want to perform Multiply(Sales) instead of Sum(Sales). How can i do it in qlik sense.