pivot-table

Background: I have a measure that calculates Total sales from a master sales data that captures actual sales and forecasted sales on a monthly basis. Sample data: And a sample looks like below: So, the June cycle and July cycle are actual sales upto Jun and Forecasted Sales from Jul to Dec...

Hello, I have this table in columns A to F <tbody> File1 Record ID ABKs MNKs Date Seg NewRecord 972567676 34305 72358 3/4/2019 22:13 21 NewRecord 685206308 8198 27174 3/4/2019 22:16 61 NewRecord 300264531 393064 10093118 3/4/2019 22:18 238 NewRecord 300264531...

Hello everyone, I am building a cash management file and I managed to get it well untill I want to finalize my pivot-table report. The thing I am trying to obtain is exactly describe here : https://www.youtube.com/watch?v=q5M20UwxY1Q but for a confusing reason I don't obtain the same result...

I am having difficulties completing an assignment, completing a pivot-table with constraints. Could anyone offer some assistance? I could email, I don't see where I can upload documents.

Hi all, I am having trouble coming up with code to select the first slicer item creating a PDF, and then deselecting that first slicer item and moving to the next one, creating a PDF and so on until the end of the slicer Is there anyone that can help? Thank you

I'm working for a construction company which bids on jobs nationwide. I have a spreadsheet with several slicers. This allows data to be restricted, of course. What I'm looking for is any way the results of this filtering can be displayed in a new worksheet. So, If I select jobs in California, in...

Hello, I have a PT named "TAL". I want to pop-up the DATE-FILTER Dialog Box by vba code. This code: Application.Dialogs (xlDialogPivotFilters).Show Dose'nt work! Is there a way to do this?... TNX!