Question
Can I change filter conditions of the destination worksheet depending on the source worksheet?
Can I change filter conditions of the destination worksheet depending on the source worksheet?
"Line chart"2. Create a calculated field and name it Source Sheet (Bar chart).
“Bar chart"3. Create a String parameter and name it Source Sheet Name.
IF [Source Sheet Name]="Line chart" THEN [Category]=[Parameters].[Category] ELSEIF [Source Sheet Name]="Bar chart" THEN (DATEPART('year', [Order Date])*100 + DATEPART('month', [Order Date]))=[Year and Month] END11. Open Cross-tab worksheet and add Filter field to Filters shelf and select TRUE.