Forum

Hi Rosa, Thanks for pointing out the error in that answer. It should be =INDEX($D$106:$G$109,ROWS($1:1),2) You're correct about VLOOKUP, it can ...

Hi Faryal, INDIRECT definitely isn't the way to go about it. Why don't you just populate the Prescribed ERA Threshold using a lookup formula like V...

Hi Scotty, Thanks for clarifying. I think you're taking the splitting of your data into separate tables too far. Ideally you'll have one fact table...

Hi Nancy, Ah, you can't group by days in Power Pivot, sorry. I've never tried to group by days in Power Pivot, so this limitation was new to me. ...

Hi Scotty, Thanks for the example. It looks like the 3rd table has an error because there are two rows for Division A and Company One, likewise for...

Hi Peter, Thanks for sharing your sample files. You can use Power Query to get files from a folder. You'll need to edit the 'sample query' it ge...

Hi Scotty, It's not clear what this '2nd Slicer' is and its relationship to the data tables in the model. By default, Slicers will filter other Sli...

Hi Nancy, In Excel for Microsoft 365 the dates should automatically group when you drag a date field to the row or column areas of the PivotTable. ...

Hi Christy, Welcome to our forum! Pivot Charts display all data in the PivotTable, you can't pick and choose. However, I can't tell from the exa...

Hi Mohammed, Welcome to our forum! It sounds like your data is in the wrong format. You can use Power Query to unpivot it so that it's in a tabular...

Hi Lalith, Can you give me an example of what you mean? e.g. do you want to see % values where you currently have 'x'? How is this percentage calcu...

Hi Shabbir, Welcome to our forum! It's great to see you're able to make use of the techniques. Answers to your questionsL 1. You have 235 days i...

Hi Juan, I think something has changed in Excel 365 and it has introduced a bug with reading text files. I've saved a pp_3_returns.csv file in the ...

Hi Justin, Welcome to our forum! Given how long this thread has taken to get a response you've probably realised the answer is that you can't do th...

Hi Jim, You can't do this with a regular PivotTable, but with Power Pivot you can. see attached. If you'd like to learn more about Power Pivot, ...