Unable to get the value by fixing this as well
I'm unable to get the value still even though i followed ur steps im stucking between two things one is year reference and other one is sum of all any other alternative formula fr this ?
1 answers ( 0 marked as helpful)
Make sure the names on your column B matches the pivot table too. For example, instead of Gross Sales I wrote Gross Margin and it wasn't working, until I changed as it show in the pivot. Hope it helps.