Quarter and Year dimensionality problem

Hi ​@Spandan98 

Please can you provide more information on what you exactly want to do ?

If it’s easier maybe you could draft an Excel quickly of the view you’d like to create which will help us understand your request.

Do you just want to set a target by Year, and then divide the target by 4 for each quarter ?

So, I have 3 different sheets in excel with 3 different quarter data. Net sales, product category, customers, regions etc.
From the picture given below you can see that I can easily calculate the aggregated metrics for the “Actuals” data, but I want to know how the “Target” data can be entered by the user.