Set analysis based on value of a field in a straight table
Below is a sample of my data set:
Metric 1 #
Metric 2 #
You'll notice that there are 2 metrics with a percentage value and 2 with a numeric value. The % metrics and # metrics are related to each other.
I have a straight table where I was to display the % metrics along with the # metric value in parenthesis
I can easily create the straight table with the Metric and the % value but I can't seem to zero in on the correct syntax for the set analysis for the portion in parenthesis. This formula should be based on the metric name plus the "#".
One more added complexity, I want all of the values to show in the straight table at all times regardless if someone happens to click on one of the metrics (so it basically needs to ignore the current selections as part of the set analysis).
Hoping this is enough to go on for someone. I don't have a simple version of my application to share as this time.
Not sure that's going to work because the sample I gave is very simplistic. The real data is much bigger with a few other elements to the data such as Country, etc. So the numeric value would need to be aggregated. Does that change the answer?