1. K

    Dynamic DAX calculation between two rows of same DAX measure (filtered rows)

    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...
  2. F

    How to set Pivot Table to get unique values and desired output

    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...
  3. D

    Pivot-Table - Difference from total runing-in

    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...
  4. A

    Excel Pivot-table with constraints

    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.
  5. J

    VBA to run through slicer

    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
  6. M

    Display results of slicer in new worksheet

    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...
  7. D

    Pivot-Table DATE-FILTER Dialog Box

    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!

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...