Excel 2010,
Hi I am having trouble creating a formula for a measurement calculation or calculated field I'd you will. I need to cart a variance measure that looks at column H (number of cases) and column B (fiscal year). I not sure how to write the formula to subtract the number cases in FY14 from the number of cases in FY13.
In the older calculated fields pivot, I use to create s field by selecting cases and the FY and subtracting if and the wizard created it for you. In measure calculation, I'm not sure how to connect the formula to reference these variables and subtract.
Thanks for any help you can offer.
Terry
Hi I am having trouble creating a formula for a measurement calculation or calculated field I'd you will. I need to cart a variance measure that looks at column H (number of cases) and column B (fiscal year). I not sure how to write the formula to subtract the number cases in FY14 from the number of cases in FY13.
In the older calculated fields pivot, I use to create s field by selecting cases and the FY and subtracting if and the wizard created it for you. In measure calculation, I'm not sure how to connect the formula to reference these variables and subtract.
Thanks for any help you can offer.
Terry
