Here is my attempt at this. I just replaced "C" with "-" and converted column to decimals. I guess you could eliminate duplicating the column and do...
In the Power Pivot course, it was suggested to try to use Explicit Measures rather than Implicit Measures. Does Mamie's question lend itself more t...
The process I have used is to open the Master file and open all the files that are linked to it. Then I "Save As" the file names I need to change, th...
Mynda's blog post
In the past I've used threshold lines in my charts. One data series as a bar chart, and an additional series as a line chart. Usually that does enou...
Thank you for your time and generosity in sharing your knowledge. Steve
Thank you so much.
I would be careful of the average of the percentages concept. Unless you are absolutely sure that the percentages are always calculated based on the ...
Mynda, For various topics posted, I try to recreate the solutions offered. I started with Nick's Nov, Dec and Jan data, and recreated going step b...
Thank you for your thoughts. I appreciate you and everyone that helps out. Steve
Mynda, I was following along your solution trying to duplicate your PQ solution myself, and a couple of questions as to how you got to your solutio...