This might be one of those things that is possible in excel, but not QlikView. We have a report that we manually do in excel that essentially calculates Churn (a loss of revenues). However, we do this compounding. So if we lose the revenues in January, we also will show that those revenues are lost in February, March, etc.
Can this be done in a table or pivot table? Can I turn this:
I'd also like to know if there is a way to guarantee the months as headers. While highly unlikely, there's no guarantee that we'll have churn in any particular month. Though I think that might be for another thread.