You are suggesting me the sheet title change dynamically but this is not the exact change which I am looking for.
I would like to change Table Header dynamically Please see the detail in my question
Is that what you wanted?
I've created a string parameter like this
and link this parameter with measures using below mentioned calculated field
Then drag your dimension and above calculated field in canvas as per requirement. To get the header of your selected parameter just drag it to column shelf and "hide field labels for columns".
workbook (version 9.3) attached for your reference. Let me know If you've any query.
Parameter selection 9.3.twbx 452.4 KB
Thanks for your response, But I haven't seen your work book.
Yes above things I am looking for do you have work book is so please attached here It was not attached earlier.
Thanks a lot I will take a look
Also one more additional requirement is like there are 2 select parameter select 1 and select 2
Select 1 has different field and select 2 has different field.
Does it possible?
Both should display in separate columns or single column? Let me know your exact requirement with some example.
Both will display in different column
Here is the example
Parameter name is Select N and Value is 5,10,15 in that Parameter.
Calculation name is "N Value" and In that calculation If user select
Calculation name is "N Value in Percent" and In that calculation If user select
N Value Calculation Describe as below
5 then it will return [5 Days Data]
10 then it will return [10 Days Data]
15 then it will return [15 Days Data]
N Value in Percent Calculation Describe as below
5 then it will return [5 Days data in Percent]
10 then it will return [10 Days data in Percent]
15 then it will return [15 Days data in Percent]
So, Right now its display below Header
Field1, Field2, N Value, N Value in Percent
But what I want is as below
parameter = 5 selected then header of table is
Field1, Field2, 5 Days , 5 Days in Percent
parameter = 10 selected then header of table is
Field1, Field2, 10 Days , 10 Days in Percent
parameter = 15 selected then header of table is
Field1, Field2, 15 Days , 15 Days in Percent
So above dynamic value I would like to display in the table header column.
Let me know if you have any doubt
Thanks In Advance
I really appreciate, I have already done the same things by making custom header but here I am losing my sorting functionality which tableau is providing as well as dashboard is automatic so its not working as expected.
If you can suggest some other work around.