Need Help on Pivot Table

[Ashif]

Hi All,

I have requirement like as mentioned below. could you please help on this. 

If you provide a small clue also really helpful to me.

Subscription_ID

Business_date

GA(Activation_Dt)

Subscription_Revenue

Sub_TYP_CD

SUB_TYP_DSC

1. This graph displays the total revenue from subscribers based on their GA month.
2. Table presents revenue data in MTD for (current month + last 4 months).
3. Revenue data is presented w.r.t. GA month (current Month + last 5 GA months).
   1. E.g. subscriber who activated in Feb 2018, what is their revenue in March, April, May and Jun and July.
   2. Or subscribers who activated in May 2018, what is their revenue in May and Jun and July.

Thanks

[Brett_Bleess]

Pretty sure you are going to need Set Analysis for this one, here is a Design Blog post that may be of some help, actually two of them, as not sure if you may need the other one or not.  

https://community.qlik.com/t5/Qlik-Design-Blog/A-Primer-on-Set-Analysis/ba-p/1468344

https://community.qlik.com/t5/Qlik-Design-Blog/Set-Analysis-in-the-Aggr-function/ba-p/1463822

It might help if you can provide some sample data and the expected output of that sample data, I think that may be why folks have not answered yet, might be a bit confused as to exactly what you have in the way of data and what you want it to look like, I know you provided some stuff, but I am not sure it is clear enough at the moment, as I know I was a little confused myself.  Hopefully the links may help, and if you want to search that area for other posts, here is the link to use for that:

https://community.qlik.com/t5/Qlik-Design-Blog/bg-p/qlik-design-blog

Regards,
Brett