Hi,
My model consists of 3 "fact" tables and several information tables (such as products, sites and so on).
I tried to connect these 3 fact tables to the "sites" table using "factory" column as a key.
The strange thing is that the connection works for just 1 of the fact tables.
When I use the "Factory" key (from sites table) as the ROWS of the pivot with the "good" fact table (table1<gs id="340986d9-f01e-4656-979d-c9db4f424cf4" ginger_software_uiphraseguid="51d684df-ebe5-40eb-bf6b-1598a6347738" class="GINGER_SOFTWARE_mark">)</gs>- it does display the result.
However, when I drag and drop the second table (Table2) to that pivot, I get an additional (blank) row that sums all the Qty instead of slicing the data by <gs id="abb925b4-2d1d-4826-ac73-28b94934462a" ginger_software_uiphraseguid="4056cdbf-bd19-4392-a65f-d2c21df71a8b" class="GINGER_SOFTWARE_mark">Factory</gs>.
Find a copy of the pivot:
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
My model consists of 3 "fact" tables and several information tables (such as products, sites and so on).
I tried to connect these 3 fact tables to the "sites" table using "factory" column as a key.
The strange thing is that the connection works for just 1 of the fact tables.
When I use the "Factory" key (from sites table) as the ROWS of the pivot with the "good" fact table (table1<gs id="340986d9-f01e-4656-979d-c9db4f424cf4" ginger_software_uiphraseguid="51d684df-ebe5-40eb-bf6b-1598a6347738" class="GINGER_SOFTWARE_mark">)</gs>- it does display the result.
However, when I drag and drop the second table (Table2) to that pivot, I get an additional (blank) row that sums all the Qty instead of slicing the data by <gs id="abb925b4-2d1d-4826-ac73-28b94934462a" ginger_software_uiphraseguid="4056cdbf-bd19-4392-a65f-d2c21df71a8b" class="GINGER_SOFTWARE_mark">Factory</gs>.
Find a copy of the pivot:
2008 | 2009 | 2010 | 2014 | 2015 | 2016 | ||||||||
Row Labels | Qty | Sum of TotalQty | Qty | Sum of TotalQty | Qty | Sum of TotalQty | Qty | Sum of TotalQty | Qty | Sum of TotalQty | Qty | Sum of TotalQty | |
Table1 | Factory1 | 10850874 | 11674323 | 10493173 | |||||||||
Table1 | Factory2 | 10914534 | 11635265 | 10393721 | |||||||||
Table1 | Factory3 | 10771032 | 11824083 | 10494397 | |||||||||
Table2 | (<gs id="160ee25b-8464-443b-9e9f-1135ca31d784" ginger_software_uiphraseguid="6bc84b7a-88ba-4b7a-bb33-6792235e8590" class="GINGER_SOFTWARE_mark">blank</gs>) | 1638095 | 2008700 | 654835 | 2454634 | 2309044 | 2389847 |
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>