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

Help in GETPIVOTDATA and Filter

Status
Not open for further replies.
P

Pearl_022

New Member
I am trying to calculate GETPIVOTDATA but I am not sue how I can get my result. I would like to get result in manner where I can see total batches and when I apply site filter It should work. I tried several things bit it is not working. Any help would be appreciated.

Attached file.

I want to make site filter work with my total batches and total rejection in another sheet (Dashboard view) when I put Getpivotdata calculation there and try to change a filter data is not showing correct result.


Thanks in advance.
 

Attachments

  • Help in Calculation.xlsx
    36 KB · Views: 4
Pearl_022
You seems to post Your threads everywhere as well as You've done duplicated ...

Help In calculation and filter

Hi, I am working on on report where I need to calculate MTD, YTD and QTD for 2020 also need to apply filter on YTD, MTD and QTD. I am able to connect filter to my graph and trend (Sparkline) but I am nit sure How I can Connect filters after calculation MTD,YTD and QTD. Attach is file for...
chandoo.org
This thread is closed now.
 
Status
Not open for further replies.
Back
Top