Showing results for 
Search instead for 
Did you mean: 
salesgirl Visitor

Issue with Custom Calculations and Filtering?

I am having issues with some of my calculations when I try to show it by region or store banner. I only have weekly data, so I have it by week start date, Week #, and Week Year. I have calculations for Sales, Sales LY, Sales YTD, and Sales YTD LY, I calculated these using VAR and FILTER functions. Basically what I'd like to do is have a visual showing the % Growth YoY and % Growth YTD, by Banner (By Region for some similar files). It appears to calculate correctly when I just put in week start with the calculations, but when I take out the week start, and try to calculate it based on Banner or Region or anything really, all of the calculations show as blank except for the total sales. I've tried looking at tons of videos and solutions online and have been left really frustrated, as I'm thinking this is probably an easy fix... Anyone have any idea what I am doing wrong?

Super User
Super User

Re: Issue with Custom Calculations and Filtering?

Hi @salesgirl ,


Do you have a Calendar table with a relationship to the Week Start of your sales?


I would create one calendar dimension table and make my calculations based on that table.


Can you share a little more information about your model maybe a mockup data setup?


Please see this post regarding How to Get Your Question Answered Quickly: (courtesy of @Greg_Deckler).




Did I answer your question? Mark my post as a solution!

Proud to be a Datanaut!