Thanks for your prompt response.
This is the solution exactly what I want. But one more additional problem is, I may get some new languages in the future. I can not able to restrict it to only two or three. Here the Language value is dynamic. That is why we keep them like key - value pair in the base table.
How can i achieve this ? As per your solution, whether I need to create some more calculated fields for the new language values? For a dynamic data set, is it correct way to create / add more calculated fields?
You can have a two different sheet.
First Sheet will have Actual value depending on N Languages
Next sheet2 for % calculation -
1. SUM(IF CONTAINS([Keyname],"Speaking") THEN [Keyvalue] END) -> Percentage of Total
Note: Even if it is have N languages then it will calculate the percentage. And then exclude customer Keyname in sheet2.
In dashboard we can showcase in single row by hiding the Date field in sheet2
If your Language is dynamic, then current solution is not too good. I created other solution in which you don't need to create %calculation for each language. its dynamic.
PFA workbook for your reference.
Hope this helps!
Example.twbx 13.5 KB
Good try! Keep playing with the tableau.
Creating separate sheet is not good option, what will you do if we have more records? you will get scroll in both the sheets and also it will not sync to each other when you scroll down to see other records.
Thanks for your suggestions.
Actually your solution is also correct. But my requirement contains a lot of dynamic values. If I used your solution then the dashboard does not good to see. But our ultimate aim is to make the reports / dashboards user friendly to customers know.
Thanks for your effort . Thank you so much .
Thanks for suggesting a solution.
Is it possible to group different measures and give them a name to it?
Consider our example that we used. In that if I have different keynames and different measures to each keyname then is it possible to group measures under each keyname?
Say, Keyname contains A,B,C. And I have some measures M1, M2, M3, M4, M5. And I want to show like
A B C
M1 M2 M3 M4 M5