Hi guys,
I have three calculation sheets:
I want to do follow calculation:
The numbers from May till August devided by sum of WDEX from the sheet " old target"
and
The numbers from September till December devided by sum of WDEX from the sheet " new target"
I worked with the case formula:
case MONTH([Date])
when 5 then [#Numbers]/SUM([old target (Calculation sum devided by sum)].[Anzahl der Datensätze])
when 6 then [#Numbers]/SUM([old target (Calculation sum devided by sum)].[Anzahl der Datensätze])
when 7 then [#Numbers]/SUM([old target (Calculation sum devided by sum)].[Anzahl der Datensätze])
when 8 then [#Numbers]/SUM([Calculation sum devided by sum].[Anzahl der Datensätze])
when 9 then [#Numbers]/SUM([Calculation sum devided by sum].[Anzahl der Datensätze])
when 10 then [#Numbers]/SUM([Calculation sum devided by sum].[Anzahl der Datensätze])
END
see the field "Calculation" in my workbook
Any ideas?
Hi Dilyana,
Not sure if it's a "solid" solution because there is no any relation between the used Datasources but find my approach as reference below and stored in attached workbook version 101.