Thank you for reply.
I have checked the link before but it depends upon the window_sum(). Would the window_sum() work with the sheet which displays a single number?
Can you help me integrating the window_sum to my code considering that I would need a single number in a sheet
Thank you very much
Can you attach a sample workbook.
Here is the attached workbook for your reference to explain the senario
Product Channel Publisher Furniture Social Furniture Social Furniture Social
2. Datasource1 (Facebook)
Product Channel Publisher Budget Furniture Social 10000
3. Datasource2 (Instagram)
Product Channel Publisher Budget Furniture Social 20000
Note that for Twitter, I dont have any datasource
I am now using a calculated field in the primary datasources as follows
if ATTR([Publisher])="Facebook" then SUM([Facebook].[Budget]) elseif ATTR([Publisher])="Instagram" then SUM([Instagram].[Budget]) END
Desired Output 1:
I want to use primary datasource as a main datasource and blend the other two datasources with product, channel, publisher and have a total budget with a grandtotal
Product Channel Publisher Total Budget Furniture Social 10000 Furniture Social Furniture Social 20000 Total 30000
1) Grandtotal: Because the Twitter is not there, I am unable have a grandtotal of the displayed. Its NULL
Desired Output 2:
I want to use a primary datasource publishers to select multiple publishers as a filter in a dashboard which displays the sum of budgets (based on selection)
a) If I click Facebook it should display 10000.
b) If I click facebook and Twitter both, it should still display 10,000
c) if I click all three, it should display 20,000
Case a works but Because of the blending, when I select more than 1 datasource, it display null for case b and c
I have attached the workbook
Sheet 1 is problem 1 and dashboard is problem 2
Will really appreciate your help
Sample Problem.twbx 30.8 KB