Help me guys!! I've been struggling to find the root cause of this problem. I have a raw data table in RAW DATA worksheet (created a relationship with table in vlookup data (Image 2) to use power pivot), and I have a pivot table OVERALL worksheet that I need to show the payload cycle for March 2021. All but 1 row showed correct data. Payload range 54.6~59.2 (image 3) should have 11 cycles (image 1). But instead, the cycles showed in the (blank) category of the pivot table. However,when I change the rated payload value from 91 to other values from far 91, like 100 and above (MAIN worksheet), the pivot table becomes accurate. I dont know why this happens. Kindly check my macro file in the ZIP file below. This is my first post. Thanks.
Bookmarks