I am trying to create a pivot table that shows the number of plans in each stage by fund, however it just shows 0 plans for all funds for all plan types which I know is incorrect as when we pull the raw data and manipulate in excel it shows very different figures. I have the pivot table rows as 'Fund' and the columns as 'Plan status' with the only filter being dashboard level to filter by the specific project.
Has anyone come across this before?
Are you using a Value? When I recreate this and don't use a value I get 0, but if I use a value of Constituent ID I get a count of each plan type.
Thank you! I'm still very new to Analytics and can't believe I forgot to add that part.