https://community.qlik.com/t5/App-Development/Pivot-table-dimension/m-p/1571765#M41663 Simplest way while loading data check the value and if its Great Britain change it to UK<BR /><BR />Alternatively if the primary keys for both are same you can choose not to load row called great Britain<BR /> Mon, 22 Apr 2019 16:59:51 GMT dplr-rn 2019-04-22T16:59:51Z https://community.qlik.com/t5/App-Development/Pivot-table-dimension/m-p/1571761#M41662 <P>HI I have pivot table there is one Dimension which has 5 values ,&nbsp;</P><P>dimension&nbsp; Name&nbsp; [Country List]</P><P>Uk&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;5</P><P>US&nbsp; &nbsp; &nbsp; &nbsp; 3</P><P>Jap&nbsp; &nbsp; &nbsp; 5</P><P>Aus&nbsp; &nbsp; &nbsp;10&nbsp;</P><P>Grate Britain&nbsp; 5&nbsp; &nbsp;</P><P>&nbsp;</P><P>i want&nbsp; UK And Great Britain as one value . can be named as UK&nbsp;</P> Mon, 22 Apr 2019 16:54:05 GMT https://community.qlik.com/t5/App-Development/Pivot-table-dimension/m-p/1571761#M41662 everest226 2019-04-22T16:54:05Z https://community.qlik.com/t5/App-Development/Pivot-table-dimension/m-p/1571765#M41663 Simplest way while loading data check the value and if its Great Britain change it to UK<BR /><BR />Alternatively if the primary keys for both are same you can choose not to load row called great Britain<BR /> Mon, 22 Apr 2019 16:59:51 GMT https://community.qlik.com/t5/App-Development/Pivot-table-dimension/m-p/1571765#M41663 dplr-rn 2019-04-22T16:59:51Z