Hey all,
I'm stuck at the following problem: I have date values (month and year) on the x-axis and some Sum formula with a set expression as my measure in a bar chart.
Now, this chart always show...
...CurrentID01', 'vCurrentID02', etc. for all KPIs. The problem is that if I try to use the result as a variable by defining another measure having the function like =$(=$(='vCurrent' & $(='$(vKPI)'))) I...
Hello, I am hoping there is a way to do this. I am trying to load calculation from excel or even the load script but when I add the field to the measure column it just displays the text and doesn't...
...ne dimension with several values. Variable contains: =getfieldselections(Item) =vRelativeSelections pick(match(Item, '=$(vRelativeSelections)',red(),Yellow(),black())) Thanks is advance.
Hello, I have a need to add some custom subtotal columns to a large pivot table. I know you can add column values together referencing the column names like this: "Column Name 1" + "Column N...
Hi All, Can anyone tell me how to use Field value as Variable Name and return the Variable Value in Table? The scenario is a little bit complicated. A case is provided to explain as below, hope i...
I have a formula that is taking quite some time to evaluate. Based on the result I want to display a different message. Is there a way to store the result in a local variable to use within the f...
Hi, today I am stuck with a special set analysis. Out of a list of technical solutions, I have to pick the smallest version that just satisfies the demand. All this of course has to take place in a...
...o it in another calculated dimension. This second calculated dimension is =mid(Aggr( Concat(Year & '-' & pick(match(UPPER(Month), 'JAN','FEB','MAR','APR','MAY','JUN', 'JUL','AUG','SEP','O...
...urpose of the pivot table in the report is the calculation of productivity's relative to the target. To calculate the Target there are variables used: ProdStaffel and ProdFactor. E...
