I have this table in the screenshot below:
The 1st Number of Records field is coming from Data Source "A"
The 2nd Number of Records field is coming from Data Source "B"
The Total Entries is a calculated field equal to this: SUM([Number of Records])+SUM([(Data Source "B")].[Number of Records])
As you can see, the Total Entries is showing me the Aggregation just when there is values in the two data sources (i.e month of July). Otherwise, it is not showing the total of April, May, June, Aug.
Is there a way to make the Total Entries appear even when I don't have data from the 2nd Number of Records (Data Source "B")?
Thanks a lot for your help,
can you attach some workbook? It will rush you help faster!!!