I am trying to create a simple bar chart that runs off subitems to show grants received by quarter. Our fiscal year is July - June so I created a formula column in my subitems that calculates the fiscal year of the payments received. The formula I successfully used to list the Fiscal quarter and year:
IF({Payment Date},“Q” & FORMAT_DATE(EDATE(FORMAT_DATE({Payment Date}),6),“Q
YYYY”),“”)
I only have 3 columns in each subitem: Payment Date (a date column), Payment Amount (a number column) and Fiscal Payment Date (the formula column). My problem is that when I go to create a bar chart to show payments received by fiscal quarter, the Fiscal Payment Date column does not show as an option to chart on the X axis.
Would appreciate any suggestions on how to create this basic chart from subitems with a formula column.