-
Re: To hide all subtotals & totals by filtering
Hi, yes, great tip, very often used both for displaying relevant information and also for exporting data according to requirement. If you have Time and Line Items as nested dimensions in column, and …1 -
Re: Workaround for a Last value function
Hi Oleg, congrats and many thanks for this far better solution : 5 lines items versus 15 in my solution, no comments ! In addition to bringing a far easier and better solution, you also make me ware …1 -
Re: Publish list subset to dashboard
Roman, To get the view you are after, create a module that uses Employees as a dimension and a boolean formatted line item named "Active". You can then create an import action that will cop…1 -
Re: How to calculate Year to date (YTD) Growth rate?
Jill King: The following formula would work to do annual YTD cumulations where VALUE2 is the item you want to cumulate and you are using a monthly timescale: CUMULATE('VALUE2') - OFFSET(CUM…1 -
Re: Change format in model (Howto)
Hi David, This is certainly one good way to achieve changing formats throughout your model, however not the best. The simplest way to complete this can be done in the following steps: (1) Go to Setti…1

