topic How to calculate the very basics incredible basics in Discussions https://community.jmp.com/t5/Discussions/How-to-calculate-the-very-basics-incredible-basics/m-p/10842#M10459 <HTML><HEAD></HEAD><BODY><P>I have a data set and use tabulate to summarize the data and publish in the exportable interactive HTML form (implementing in a website where exporting to excel does not help).</P><P>However I am unable to do it. The bottom tabulate takes the mean of several rows and I need as an aggregate the sum of those means which should be 827102,270 or vica versa</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="8027_Screen Shot 2015-02-06 at 16.38.20.png" style="width: 288px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/1212i0A07AFA72BA16C3C/image-size/medium?v=v2&amp;px=400" role="button" title="8027_Screen Shot 2015-02-06 at 16.38.20.png" alt="8027_Screen Shot 2015-02-06 at 16.38.20.png" /></span></P><P>I could add the sum of rows and I would need the mean of those sums but it also seems to be impossible. Does anyone have any idea rather than making a summary table creating a new column adding formula recalculating and still not being able to export as Ineractive HTML of the tabulate?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="8028_Screen Shot 2015-02-06 at 16.39.40.png" style="width: 548px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/1213i1DBBAF9A2404F969/image-size/medium?v=v2&amp;px=400" role="button" title="8028_Screen Shot 2015-02-06 at 16.39.40.png" alt="8028_Screen Shot 2015-02-06 at 16.39.40.png" /></span></P></BODY></HTML> Tue, 18 Oct 2016 22:32:11 GMT saitcopuroglu 2016-10-18T22:32:11Z How to calculate the very basics incredible basics https://community.jmp.com/t5/Discussions/How-to-calculate-the-very-basics-incredible-basics/m-p/10842#M10459 <HTML><HEAD></HEAD><BODY><P>I have a data set and use tabulate to summarize the data and publish in the exportable interactive HTML form (implementing in a website where exporting to excel does not help).</P><P>However I am unable to do it. The bottom tabulate takes the mean of several rows and I need as an aggregate the sum of those means which should be 827102,270 or vica versa</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="8027_Screen Shot 2015-02-06 at 16.38.20.png" style="width: 288px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/1212i0A07AFA72BA16C3C/image-size/medium?v=v2&amp;px=400" role="button" title="8027_Screen Shot 2015-02-06 at 16.38.20.png" alt="8027_Screen Shot 2015-02-06 at 16.38.20.png" /></span></P><P>I could add the sum of rows and I would need the mean of those sums but it also seems to be impossible. Does anyone have any idea rather than making a summary table creating a new column adding formula recalculating and still not being able to export as Ineractive HTML of the tabulate?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="8028_Screen Shot 2015-02-06 at 16.39.40.png" style="width: 548px;"><img src="https://community.jmp.com/t5/image/serverpage/image-id/1213i1DBBAF9A2404F969/image-size/medium?v=v2&amp;px=400" role="button" title="8028_Screen Shot 2015-02-06 at 16.39.40.png" alt="8028_Screen Shot 2015-02-06 at 16.39.40.png" /></span></P></BODY></HTML> Tue, 18 Oct 2016 22:32:11 GMT https://community.jmp.com/t5/Discussions/How-to-calculate-the-very-basics-incredible-basics/m-p/10842#M10459 saitcopuroglu 2016-10-18T22:32:11Z