Forum Discussion
Calculation derived from measure
Thank you andre, that gets me closer to what I need. I am now able to see the correct enrollment status per week. Now my next conundrum is how to then pivot on that FT/PT value. The client wants to see the number of students and the credit hours broken out by FT and PT.
This pivot should have 4 columns with count and total credits for FT and the same for PT.
If I try to add the FT/PT calculation to the pivot table columns, it won't let me. I can only add it as a Value.
You need to use this matrix
then place school in rows
ft/pt istatus in columns
and then your measures in values.
this should give you the 4 columns your looking for
Yes, but unfortunately, FT/PT is a calculation derived from the running total, and as such, cannot be used in columns. That is my conundrum. I need to be able to break out the headcount and credit hours into separate columns for FT and PT.
if your its in a calculated column it will work
if you send me a sample i can whip it together