1 of 1 people found this helpful
I might be missing something, but not sure you need a LOD for this (if that's the only thing you want in the view).
Try just using a table calc like:
and then use right click / edit table calc / compute using and select specific dimensions / "value".
Or the pane defined by the "group".
Please see the excel data below. You will be required to add the sr no to make each row distinct else it will aggregate the output by group.
Please refer to the screenshot below and arrange the dimensions and measure as per shown in the pictures. I have also shown what table calculation that I have used. along with the value2 field formula. I am attaching the tableau 10.1 version of the workbook since I am using latest version.
Thanks and Regards,
I think that's sounds perfect. Let me give it a try to it.
Thanks both. What should I do if I want to derive a variable permanently in the table, so I can avoid using the table calculation (if I'm not wrong this calculate the variable dynamically) depending on what I put in the row/column? For example I want to plot a graph which is the sum of all value2, I would be dropping group/sr_no in the row or column.