Forum Replies Created

Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • September 15, 2017 at 10:04 pm in reply to: #8340

    Mark_Melb
    Participant
    • Started: 0
    • Replies: 2
    • Total: 2

    Hi

    Lazy method …but u could use a calculated column plus a measure.

    Max column:=max (qty)-qty

    Count max qry:=calculate (countrows (table 1),filter (table 1, max column = 0))

     

     

     

    September 14, 2016 at 1:16 am in reply to: PowerPivot 2010 Delay Pivot Table Update #6066

    Mark_Melb
    Participant
    • Started: 0
    • Replies: 2
    • Total: 2

    Hiya.
    Grab olap pivottables extension. Google that. Unpack…install…right click in a pivot and select disable autorefresh.
    A little buggy at times…but 90 percent of the time hassle free.

  • Author
    Posts
Viewing 2 posts - 1 through 2 (of 2 total)