I have a pivot table with one vertical dimension and one horizontal dimension. There is a situation where a specific combination of
dimensional values is not represented in the data but still has a cell in the pivot table. Both
dimensional fields exists in the same data model table. Hence, i am getting type of missing values with just one data model table and two dimensional fields.
look at the example below:-
In the example shown in the picture, there are amounts for all quarters in 2011 but not for Q3 and
Q4 2012. When the pivot table is calculated, an algorithm loops over all records in the database.
Since there are no data records for the last two quarters, the consequence is that the expression is
never calculated for these cells (middle and rightmost tables).
Is there a way if i could replace the MISSING(-) values with Numeric 0? May be through set analysis?
Thanks a lot for the help.
Thanks a lot, this is working file. However i am facing a new problem when i am converting the Pivot into Bar chart. Few Per Int are missing from the graph. Could you possibly have a look at this last piece and help me with the solution? Thank you very much again. you are genius.
Now the bar graph is showing all the Per Int, but if you compare the 20-25 per int of Bar graph vs above pivot, the above pivot has -18%, but if you look graph for the same Pet Int it is showing nothing. Please let me know if you have any questions.