Forum

Hi Cheryl, SharePoint uses the web connector, not a folder connector, therefore you don't need a dynamic path as such, you just need to ensure that...

Hi Richard, Welcome to our forum! What is 'scen1'? Is this the source data for 'scen1pivot'? If so, then you need to recreate the second PivotTa...

Hi Dave, Not that I'm aware of. This is a known limitation of URLs in PivotTables. You could add a column beside the PivotTable that uses the HYPER...

Hi Pieter, You can't auto generate the dimension table with Power Pivot, but you can use Power Query to automate it based on the values in the fact...

Hi Pieter, I think it's time to learn Power Pivot 🙂 I can see from your new table and subsequent PivotTable that you don't understand how to crea...

Hi Michelle, Welcome to our forum! I can't replicate this magical copying of data from the coloured tabs to the month tabs in the file you share...

Glad you got it working, Philip!

Hi Hima, Move the Higher, Lower and Same CL to the row labels and then use Sparklines. There's too much data here to plot in a single chart. The ot...

Or just create a sample file with a small amount of your data.

Hi Hima, Welcome to our forum! Please upload your picture again. You need to click the yellow 'start upload' button. That said, it would be far bet...

Hi Ross, Welcome to our forum! Thanks for sharing your file. It makes the question easy to understand and answer. There are a couple of issues: ...

Hi William, It's still called absolute referencing and you use the dollar sign to stipulate this. If you want the formula to move without chang...

Hi Katherine, Yes, you'll need to create 3 separate rules, one for each colour. The rules then need to include a criteria in the AND formula to che...

Hi Pieter, Not sure. You'd have to test it on your dataset. It's often easier to follow the formulas when you break it out into its separate compon...

Hi Pieter, Welcome to our forum! Thanks for sharing your sample file. Please see the solution in the attached file which uses the IF formula you cr...