Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I am trying to add a caluculated dimension on a chart which has two drill downs, I have tried using it in the general tab calculated dimension box and in the dimensions but neither is working. Please help
Thanks
Rosie
Ok this could be my problem then as I am using an aggregated function here is the caluclated dimension example:
=
IF(AGGR(Count(IF([Unanswered] ='0', ID),[Questiondrill], [Country/Base/Man])>6,[Country/Base/Man]))
where question drill and country/base/man are drill down groups
I actually want the rule not to report less than 7 responses across all of my tabs is there a way to do this as well?
Thanks in advance
Rosie
Hello, Rosie.
I see a small bug in your expression - you miss one symbol ')' , try use like that:
IF(AGGR(Count(IF([Unanswered] ='0', ID)),[Questiondrill], [Country/Base/Man])>6,[Country/Base/Man]))
no unfortunately that doesn't work either. Sorry I should have mentioned before that the groups are cyclic groups rather than drill downs.
Thanks
Rosie