Last seen: May 22, 2025
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...
It is not inexplicable. The return includes interest, which is calculated from issue date to maturity. If you move the issue date, then more (or less ...
The interest is calculated from issue to maturity. If you make the issue date earlier, then the portion of interest applicable to the settlement value...
You've misunderstood the date parts. You should add a year for the maturity date, not 360 days. If you check the results of YEARFRAC(B2,B3) for exampl...