Forum

Hi Darko, I'm sorry but I don't have the Javascript skills to do it either. I would have to search the web for ideas too, which I've done before an...

You're welcome! I'm glad that's what you were after.

Hi James, Thanks for clarifying. You need to add these groupings to your source data, then you can add 2 'count of DLWO#' to your values area and s...

Hi James, Thanks for sharing your file. It helps a lot. Select a cell in your vales area, say D5 > right-click > show values as > % of ...

Hi Singhg, Power Query can help you consolidate the data into one sheet so you can use regular PivotTables as described here: Or Power Pivot c...

No worries, Adrian. It'd help if they didn't keep renaming things 🙂 Glad you figured it out.

Sure is, Christopher. Glad you figured it out and thanks for letting us know.

Hi Steve, Thanks for providing the data. The technique you can use to move the data on the second row up, so all data is in one row, is Modulo with...

You're welcome. BTW that 'hint' is also covered in session 4.01 where I show you how to structure your data to nest axis labels. You might like to ...

Hi steve, Please provide a sample file in the format you receive the data (CSV, Text etc.). I don't have time to recreate your data from scratch. ...

I know there is a lot to take in. As you practice and implement more you'll recall the different techniques more easily. I think it's a good idea t...

Hi Tobias, There is an element of blockhead-itis 😉 or maybe you haven't practiced the dashboard course sessions and are trying to go from my exam...

Hi Tobias, Correct, Slicers can only control PivotTables that are from the same data source and share the same Pivot Cache. You could possibly w...

Hi Tobias, Not in a PivotChart. You'd have to create a manual chart from the PivotTable data as described here: You have 3 options for creatin...

Hi Marianne, You get all the dates from the 'Invoice' table because you've put that field in your PivotTable but what you really should do in this ...