To show sales by month for tenants at different malls.
I've created a bar chart to show total sales per Year.
I'm also trying to create a chart to show sales per square feet per year.
I need to average the square footages for each specific tenant over the year, and then take the sum of those square feet. However, I only want to include tenants who have 12 full months of sales for that year.
i created a sample qvw to try to demonstrate my issue in more detail. the formula above worked great when only one year was selected. but i am using set analysis in my charts to show certain years regardless of what is selected. see attached file, hopefully that helps you help me
Update: this isn't in the attached file, but i am getting pretty close by changing the formula to
but i think it's requiring that the tenants are there for 12 months for each of the years that i select.
But if I'm selecting 2010, 2011 and 2012, and a tenant has 12 months of sales in 2011 only, then I want to show their avgSF in that year only. but i think since it doesn't have 12 months in all three of those years, it's excluding their SF completely from all years.