HI EXPERTS,
I HAVE PIVOT TABLE WHICH IS GATHERING DATA FROM TWO DIFFERENT TABLES. RELATIONSHIP IS WORKING FINE (I THINK) BUT I AM STUCK AT ADDING A "FIELD" OR A "COLUMN" TO GET THE RESULTS BY WHICH WILL BE THE END PRODUCT OF DEDUCTION FROM "TABLE 1" TO THE ITEMS OF "TABLE 2". BOTH VALUES ARE ALREADY BRINGING NUMBERS TO THE "PIVOT TABLE".
1) CALCULATED FIELD / CALCULATED ITEM IS GRAYED FOR SOME REASON.
2) TO EXPLAIN WHAT I AM TRYING TO ACHIEVE IS AS BELOW:
A) PIVOT TABLE IS A COMBINATION OF TWO DIFFERENT TABLES. TABLE ONE IS NAMED "LC" AND TABLE TWO IS "INV".
B) "LC" TABLE HAS A COLUMN/FIELD NAMED "AMOUNT" AND "INV" TABLE HAS A COLUMN/FILED NAMED "VALUE".
C) BOTH "AMOUNT" AND "VALUE" FIELDS ARE IN PIVOT TABLE WHICH ARE BRINGING DATA AS I NEED.
D) "AMOUNT" FILED IS DISPLAYED ONCE IN EACH GROUP AND THE "VALUE" FIELD IS REPEATING SEVERAL ROWS UNDER SAME GROUP WHICH IS FINE.
E) NOW I WANT A SEPARATE COLUMN OR FIELD WHERE I CAN DEDUCT THE SUBTOTAL "VALUE" FROM THE "AMOUNT" FIELD. PLEASE GUIDE / ADVISE HOW TO CREATE / ADD ONE?
SCREENSHOTS ATTACHED.
PLEASE GUIDE / ADVISE.
I HAVE PIVOT TABLE WHICH IS GATHERING DATA FROM TWO DIFFERENT TABLES. RELATIONSHIP IS WORKING FINE (I THINK) BUT I AM STUCK AT ADDING A "FIELD" OR A "COLUMN" TO GET THE RESULTS BY WHICH WILL BE THE END PRODUCT OF DEDUCTION FROM "TABLE 1" TO THE ITEMS OF "TABLE 2". BOTH VALUES ARE ALREADY BRINGING NUMBERS TO THE "PIVOT TABLE".
1) CALCULATED FIELD / CALCULATED ITEM IS GRAYED FOR SOME REASON.
2) TO EXPLAIN WHAT I AM TRYING TO ACHIEVE IS AS BELOW:
A) PIVOT TABLE IS A COMBINATION OF TWO DIFFERENT TABLES. TABLE ONE IS NAMED "LC" AND TABLE TWO IS "INV".
B) "LC" TABLE HAS A COLUMN/FIELD NAMED "AMOUNT" AND "INV" TABLE HAS A COLUMN/FILED NAMED "VALUE".
C) BOTH "AMOUNT" AND "VALUE" FIELDS ARE IN PIVOT TABLE WHICH ARE BRINGING DATA AS I NEED.
D) "AMOUNT" FILED IS DISPLAYED ONCE IN EACH GROUP AND THE "VALUE" FIELD IS REPEATING SEVERAL ROWS UNDER SAME GROUP WHICH IS FINE.
E) NOW I WANT A SEPARATE COLUMN OR FIELD WHERE I CAN DEDUCT THE SUBTOTAL "VALUE" FROM THE "AMOUNT" FIELD. PLEASE GUIDE / ADVISE HOW TO CREATE / ADD ONE?
SCREENSHOTS ATTACHED.
PLEASE GUIDE / ADVISE.