Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everyone,
i've got an issue to solve and i need your help. I will use a simple example to explain clearly what i want to get.
I've got a pivot table like the one in the image below.
In this pivot there's only one simple expression "sum(QTA_IMPEGNATO)" which leads to that result.
As you can see, the pivot table has several columns in the format "Year-WeekNumber" (descending order in this case) and in those columns appears the result of the expression sum(QTA_IMPEGNATO).
Obviously, the "2017-24" column is missing because there's no QTA_IMPEGNATO values in that columns.
IS THERE A WAY TO LET THE COLUMN "2017-24" APPEARS EVEN IF IT HAS NO VALUES IN IT ? I WANT TO GET SOMETHING LIKE THIS:
COD_ARTICOLO | SETTIMANA | 2017-28 | 2017-27 | 2017-26 | 2017-25 | 2017-24 | 2017-23 |
ABCDE | 2 | 3 | 1 | 1 | 0 | 1 |
By the way, the table IMPEGNI has a set of data like these (2017-24 has no values):
COD_ARTICOLO | SETTIMANA | QTA_IMP |
ABCDE | 2017-28 | 2 |
ABCDE | 2017-27 | 3 |
ABCDE | 2017-26 | 1 |
ABCDE | 2017-25 | 1 |
ABCDE | 2017-23 | 1 |
here's the db structure
thanks in advance to everyone!
Hi,
Create the Master Calendar and Link with SETTIMANA. Then It will show, even if there is no data.
As you don't have that date in your data, you need to manually create one master calendar and link with you model
i already have a Master Calendar in this situation, and it's the one called CALENDARIO, that is linked to IMPEGNI
on the field SETTIMANA.
In that table i have a set of data like these:
SETTIMANA
2017-22
2017-23
2017-24
2017-25
2017-26
2017-27
2017-28
and so on... (the field INDICE is irrilevant...)
Thus i don't know why i can't get the value "2017-24" appear in the pivot.... even if i choose "show all values" in the dimensions options... what am i doing wrong ?
Did you try to uncheck the 'Suppress Zero values' in the Presentation tab?