This content has been marked as final.
Show 4 replies
-
1. Re: Creating a calcualted field from a subset of a dimension
pooja.gandhi Jul 14, 2016 9:22 AM (in response to Johnson Muthii)Hi There!
What you have is a dimension with multiple members. And what you want is unpivoted measures so they can individually be used on the view. Create separate calcs for applicants, accepted and enrolled like so:
Applicants: countd(if ([App Status]) = 'Applicants' then [Appno] end)
similar ones for accepted and enrolled. Percentage would then just be:
[Enrolled]/[Accepted]
-
2. Re: Creating a calcualted field from a subset of a dimension
Johnson Muthii Jul 15, 2016 2:43 AM (in response to pooja.gandhi)Hello Pooja,
Thanks so much for you reply. Will try this.
Regards.
-
4. Re: Creating a calcualted field from a subset of a dimension
Johnson Muthii Jul 18, 2016 5:35 AM (in response to Johnson Muthii)Hello Pooja,
I finally managed to do it, thanks so much for the directions.
Regards.