Hi All,
I'd like to ask how to create a calculated pivot table based on this relationship? my goal is to create a pivot table with this columns
1. ITEM CODE [from Tbl_ListProduct]
2. PRODUCT [from Tbl_ListProduct]
3. QTY [SUM from Tbl_SalesDtbs] - based on slicers from YEAR
4. RunningRate...