I want to add Opening & Closing balance Metric for each category, in Pivot table. Pivot table want to show value based on Date Range Filter Expected Output Labels: Need Help Message 1 of 19 1,485 Views 0 Reply All forum topics Previous Topic Next Topic 18 REPLIES v-alq-msf...
I converted your data ranges to actual excel tables. The columns in grey have formulas. Do not overwrite them. The values in the date column are not being recognized as dates. I created a column "Converted Dates" that transforms your values into a date. Please continue to use your colum...