Okay, so want to calculate North / West % in below pivot. Let’s say you want to calculate certain percentage or similar…
Unfortunately, I can’t explain this because squirrels know more MDX than me. If your answer is 3 & you are using Excel 2013 (or power pivot), you can use either Sets feature or MDX formulas to mimic blank rows. If your answer is 3, you can use calculated item / fields is your best option. If your answer is 2, again above approach is still good. If your answer is 1, the above approach (copying pivot and pasting as references) gives you most control over the layout and formatting.
So how DO we insert a column in the pivotĭon’t bother inserting the columns in actual pivot table. In fact the error message is so long, I can’t even fit it in one image on this blog.
We all know pivot table functionality is a powerful & useful feature.