K
Kathy
I am doing a quality dashboard. On the left side I have 1 column for "Goal,"
4 columns for each quarter, 1 column for the year to date and 1 column for a
red, yellow, or green flag. To the right I have columns for each month for
the data to be entered monthly.
The problem is that when I enter the monthly data, it does calculate in the
appropriate quarter, but the quarter data does not appear in the YTD column.
It wants all 4 quarters of data entered before it will give me a YTD. I want
it to calculate as I go. Any suggestions?
4 columns for each quarter, 1 column for the year to date and 1 column for a
red, yellow, or green flag. To the right I have columns for each month for
the data to be entered monthly.
The problem is that when I enter the monthly data, it does calculate in the
appropriate quarter, but the quarter data does not appear in the YTD column.
It wants all 4 quarters of data entered before it will give me a YTD. I want
it to calculate as I go. Any suggestions?