topic Pivot table relative percentage in QlikView

topic Pivot table relative percentage in QlikView https://community.qlik.com/t5/QlikView/Pivot-table-relative-percentage/m-p/801217#M282773 <HTML><HEAD></HEAD><BODY><P>Here in this pivot table for the field volume i have written the expression</P><P></P><P></P><P>=if(Dimensionality()=0,</P><P>  Sum(Aggr(sum(Query3.Volume),Query3.Water_System,Query2.REGION,MonthName)),</P><P>   if(Dimensionality()=1,</P><P>     Sum(Aggr(sum(Query3.Volume),Query3.Water_System,MonthName))</P><P>  </P><P></P><P>  ))</P></BODY></HTML> Sat, 31 Jan 2015 09:00:01 GMT 2015-01-31T09:00:01Z Pivot table relative percentage https://community.qlik.com/t5/QlikView/Pivot-table-relative-percentage/m-p/801217#M282773 <HTML><HEAD></HEAD><BODY><P>Here in this pivot table for the field volume i have written the expression</P><P></P><P></P><P>=if(Dimensionality()=0,</P><P>  Sum(Aggr(sum(Query3.Volume),Query3.Water_System,Query2.REGION,MonthName)),</P><P>   if(Dimensionality()=1,</P><P>     Sum(Aggr(sum(Query3.Volume),Query3.Water_System,MonthName))</P><P>  </P><P></P><P>  ))</P></BODY></HTML> Sat, 31 Jan 2015 09:00:01 GMT https://community.qlik.com/t5/QlikView/Pivot-table-relative-percentage/m-p/801217#M282773 2015-01-31T09:00:01Z