Creating a filterable year-over-year Waterfall Chart with multiple measures using internal data densification

For today I have something hopefully interesting for many. A Waterfall chart is a quite common type of chart whenever we look at financial data but obviously can be used in many regards. In any case, it always does the same: it explains how we come from a starting reference to an end value by … Continue reading Creating a filterable year-over-year Waterfall Chart with multiple measures using internal data densification

Quartlery year over year comparison when one QRT isn’t fully done yet

Month on Month, Quarter on Quarter or Year on Year comparisons are an absolute standard in many analysis and/or dashboards. Recently the question came up how to do a quarter on quarter analysis on a yearly basis (that is, compare Q1 to Q1) when the current quarter is not yet finished. Understandably, the user wanted … Continue reading Quartlery year over year comparison when one QRT isn’t fully done yet

Transferring results of a table calculation as a fixed value into another sheet at the example of a Top N ranking

A returning question on the forums is when users want to take the results of filtered table calculation(s) as a fixed value or value set to another sheet which actually is not possible. In this blog post, we will see three option to do the undoable.