That seems a little misguided, unless the relative magnitude of the 3 values is always the same. I assume your reforecasted budget could be larger or smaller than the original budget. It sounds like you want the height of the stack to be equal to the largest value, with the others superimposed on top of it. There may be…

Hi @Regie Mercado There should be an item labeled "Measure Labels" in the Excluded drop area at the bottom of the pivot edit page. Move that into the "Columns" drop area.

My quick workaround would be to create a 2nd user name column, containing UPPER(user name) and match on that. It can be hidden in your actual report, if I'm remembering correctly.

Just use a pivot table instead of a table. Place Item Name in the row box and Rq Qty in the measures. If aggregation is set to "sum", you'll get what you have described.

Hi wayne, If you use 1.00/x in the POWER function, rather than 1/x, it works as expected.

If I use POWER(XXXX,1/3), I get 1.00. If I use POWER(XXXX,0.33333) I get the correct (approximate) answer.

Use a filter formula in each column of a single row. e.g.: FILTER ("Salary" USING "Title" IN ('CEO')). Do the same for Employee. Use a third column to divide one column by the other.

I'd like to display 3 tables in increasing levels of detail, using each as a filter for the next. Can't do it without this change requested above.

Perhaps a union (minus) query, where the first leg contains your whole data set, and the minus leg is the same, but filtered on the two months in question. The resulting remainder will be those employees that did not work in the two selected months.

I notice that the original CASE statement is missing an ELSE clause. That can be a problem.

Thanks again, Ram. Clearly, I'm not the first to find this annoying.

Hi Ram, Thanks for the quick reply. That closed state you describe only persists if I close them all before logging out each time. I work in many dashboards all day, so this is a step I'd avoid, if possible. If we had a smooth scroll, rather than the one-line-at-a-time arrow button, it would be a lot better. The Favorites…

Thanks, Marcelo. I'll do that. If I'm the only "sufferer" in this situation, this idea can be removed. Jerry

+1 for this idea.

If you don't have double columns enabled, you can create a variable prompt based on your concatenation. Say your prompt produces a presentation variable "varConcat", with a value like CityCode||' - '||CityName, say "13 - Rome". The analysis can be filtered like: CityCode=Left('@{varConcat}{xxx}',2)

Hi Indra, I have done this on a dashboard, but not on a stand-alone analysis. I needed 4 column headings for year1, year1+1 year1+2, and year1+3. I have a repository variable for year1 (called "STIPYear1"). I created a hidden dashboard prompt that creates 3 presentation variables: varSTIPYear2, varSTIPYear3, and…

Just commenting to reinforce all of the above comments. Presentation variables are used throughout our existing dashboards. We won't be getting much use out of DV until PVs can be used in them.

Hi @Steelbird , Sorry - I'm rarely on here now. If you still need this, leave the customer name in the data, and use a pivot table for your summary. Set the agg rule to max on your rank columns. Data, using your formulas, with pivot table below:

You are showing it in a column editor window. It goes into a filter in the criteria tab. Here's a two-column query, to be filtered on Employee Last Name: Select "Filter", then "Convert to SQL":" Enter the filter in the "Advanced SQL Editor" window: My prompt looks like this: My results look like this: A slightly more…

In the filter of the query that you are prompting.