Imagine that I have this table and I want to know the percentage for “chocolate” between February and January:
To do that, what I will do first, it is to create an index, it will allow me to select one particular cell:
So I will get this result and since I am satisfied, I will click on “close & apply”:
Now I will create a “new measure” by clicking on the right button (home -> new measure):
So to calculate the percentage between February and January for “chocolate”, let’s put this formula:
LOOKUPVALUE([argument1],[argument2],2)/LOOKUPVALUE([argument1],[argument2],1)
Then in the “format” field (measure tools -> format), select “percentage” and below, I will make sure that “2” is displaying. If you prefer to have only 1 or 3 decimals, just change it.
Now let’s create a score card and see the result, to do that, in the “visualizations”, select the “card” button and in the “fields”, put your “measure”, and this is the result:
To change the name “measure”, there are 2 options:
For the second option, you can also rename it by changing the name in the formula:
Just take note that by renaming it in the table, it will not change it for your visualization, in this case, use the first option or remove it and put it again into the “fields” field.
When you are managing a team, “how to be a good manager” is the “must”...
As manager, I am doing many reports, even when I was an ITIL consultant, I still needed to do many reports...
ITIL V3 is going to be obsolete...
Managing an IT service when I start a new company is not an easy task, particularly true, if the service...