• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Power Pivot: Show last month data from slicer selection in grand total

Hi,

Is there a way to adjust the formulas so the grand total values is the values of the last month in the slicer selection?

If the slicer selection is januar to desember the values should be desember data that is:
Faste ansatte menn 379
Faste ansatte kvinner 31
Faste ansatte totalt 410
Innleide arbeidstakere kvinner* 0


I have attached the workbook.

Thank you in advance for any help :)
 

Attachments

  • HMS rapport 2023.xlsx
    721.5 KB · Views: 3
Back
Top