Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have a question.
I have created a new Dimension [Country] as fx is: =ValueList('Swden', 'Denmark', 'Norway').
And when i´m adding a new Mesaure, i have 3 different functions (because they have each specific bookmarks that I connecting to. So for example i have the function for Denmark which should give me 20 000, but instead it gives all of them 20 000, which can see below.
Country | Population |
Sweden | 20 000 |
Denmark | 20 000 |
Norway | 20 000 |
Does anyone know how I can type an FX which should give me something like this
<[Country] = 'Sweden'> = function 1, <[Country] = 'Denmark'> = function 2, <[Country] = 'Norway'> for function 3,
and the result should look like this:
Country | Population |
Sweden | 60 000 |
Denmark | 20 000 |
Norway | 300 000 |
Right now I can create seperate KPI chart´s but it take alot of space but it works. But I tried to make it take less space and therefore I wanted to create a new table.
Best regards,
Confused_Rob
I found the solution now.
This youtube example helped me: https://www.youtube.com/watch?v=Of4aEGiPWBE
Best regards,
Confused_Rob
I found the solution now.
This youtube example helped me: https://www.youtube.com/watch?v=Of4aEGiPWBE
Best regards,
Confused_Rob