Forum

Specify an action for the values column (eg Sum). The formula should look like: = Table.Pivot(#"Changed Type", List.Distinct(#"Changed Type"[H...

There is no code there to change font? Application.Caller will only work if the code is called by clicking a button.

You can't write Or criteria like that - you have to repeat the test of the shape name each time. If shp.Name = "btn_Hetton" Or shp.Name = "btn_GMH"...

If you only have one table, then a PP pivot should behave much the same as a regular pivot table. Any chance you can post a workbook?

From your description, I'd say your relationships are not set correctly, or there's an issue with which fields you are using in the pivot table. Filte...

FYI, cross-posted here: In future, please provide links if you cross-post. Thanks! 🙂

A PP calculated field is a measure. All you need to do in PP is explicitly add the SUM function that a regular pivot table implicitly does (since it's...

You can use something like this: File_Name = Range("E4").Value & Format$(Range("H4").Value, "000") & ".xlsb"

FYI, that formula did not require array entry since the criteria involved used an array constant.

Also cross-posted here:

It would be easier to help if you posted a link to a workbook, rather than pictures.

This page will explain to you how YIELDMAT works (it's for Calc, but Excel works the same):

That is clearly not the case. If it were, then using YEARFRAC or DAYS360 on your dates would give you 1 and 360. They do not.

What is the source data - a spill range (or several), regular range, or table?

I know that. But if you simply add 360 days to a date, you have actually added 11 months plus a certain number of days. Each of those months will only...