I'm not sure if this quite got there, but please if the below can give ideas.
This method used Table Calculations. You can likely adapt it LODs
IF NOT [Weekend Boolean] THEN [Quantity] END
[Selected Dates Quantity]:
IF [Select Period]="day" AND ATTR([Order Date])=[Date Selection]
ELSEIF [Select Period]="week" AND DATEPART('week',ATTR([Order Date]))=DATEPART('week',[Date Selection])
ELSEIF [Select Period]="month" AND MONTH(ATTR([Order Date]))=MONTH([Date Selection])
// etc. for other parameter selections
WINDOW_SUM([Selected Dates Quantity])
Repeat the above two calculations for the NonWeekend version,
using WINDOW_AVG for the aggregate.
The final view filters out the duplicate copies using an Index Filter.
Please see workbook v10.5 attached in the Forum Thread.
With regards to the parameter hiding, you maybe could add
address that using Sheet Swapping:
277212weekend.twbx 1.2 MB
Sheet Selector will not work because i want to hide Date Parameter based on the value in another parameter .
Even If I put parameter in one sheet and select it, parameter doesn't hide .
correct me if I am wrong with this.
That may be the case.
Best to search through the content of Joe Oppelt
who has done extensive work on sheet popping and swapping.
Though not your situation, here is an example, :
But this does not work for me . I have date Parameter automatic and not any derived field from the data. I do see we can show parameter if it is a list and have them in one sheet. But my end user want to see Date Parameter and automatic.