Forum Discussion

Vitalie_C's avatar
Vitalie_C
Copper Contributor
Feb 22, 2024

PIVOT Table, MAX formula

Hello Team,  I am seeking some help and a solution to my issue. If it was already covered, kindly point it out to me. Thank you. Example of the report on the link: File  Link with the screenshot: ...
Excel
Formulas and Functions
Lorenzo's avatar
Lorenzo
Silver Contributor
Feb 22, 2024

Hello Vitalie_C 

 

With Power Pivot (assuming you run Excel / Windows):

 

A few intermediate Measures are not visible in the Pivot fields but are in the Model

  • Vitalie_C's avatar
    Vitalie_C
    Copper Contributor
    Feb 23, 2024
    Hi Lorenzo, i see that i works as requested, thank you ! Can you help me with the steps too?

    Thank you
    • Lorenzo's avatar
      Lorenzo
      Silver Contributor
      Feb 24, 2024

      Hi Vitalie_C 

       

      Can you help me with the steps too?

      What do you exactly mean/wants (currently away - don't expect timely reply)