I have two reports – Main and Detail report:
I have applied hyperlink on the Date column which passes Calendar day, Plant and Material to the detail report.
Now, if I select one plant and one material for a date range(1st oct till 31st oct), the hyperlink works fine. But if I select two plants, one material for date range I get #Multivalue error.
If I apply “Avoid duplicate row Aggregation” , I don’t get the #Multivalue error but now I have two rows for one date.
I don’t want to display two rows for single date. The measure values (Gallons, ($) etc) should show the summation for both the rows (1st oct) in one row .
I tried using In, ForEach and ForAll but i think i am not using the formula correctly.