nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

how to display table and chart by grand total and total

sumathra

<div>Hi...Am trying to display a chart and table in Report with Grand Total and Overall total of table and chart by selection of three parameter....but am struggling to pass parameter and to get grand total and total of chart and table...i have tried but no result .....i have attached sample db for reference...kindly go through it and provide solution for this report...by providing sample db...</div><div> </div><div><a data-ipb='nomediaparse' href='https://www.dropbox.com/s/iuojlqeo6odjs0c/sample.rptdesign'>https://www.dropbox.com/s/iuojlqeo6odjs0c/sample.rptdesign</a></div><div> </div><div>thank in advance..</div>

Find more posts tagged with

Comments

micajblock

<p>What is the difference between grand total and overall total? Can you provide a screenshot of that you are trying to accomplish?</p>

sumathra

<p>if u look at the sample Report example which i have tried three are three table so each have a total (i.e) grand total and below of three table there is one column i.e is overtotal of all table....</p>

micajblock

<p>OK, so what do you want the chart/table to look like? Also in your real report what are the 3 data sets and why do you need multiple data sets? Please provide as much details as possible so that an appropriate solution can be provided.</p>

sumathra

<p>sir i have attached a screenshot for u r reference...so my requirement is am having a three parameter like </p><p> </p><p>

>department like All,Main floor,Second floor,third floor</p><p>

>Group like All,water, chocolate,..etc</p><p>

> price Range like All,100,500,1000</p><p>this all are in databases...so now i have select a All from three parameter..</p><p>it have to display three table and two chart one is for series wise and other one is total of all series....and then if i change parameter <span style="font-size:14px;">appropriate table and chart have to change ..like wise it go...how to </span><span>achieve ,,kindly provide sample db..</span><span style="font-size:14px;"> </span></p><p> </p>

sumathra

<p>kindly reply for the topic....</p>

micajblock

<p>Sorry but I do not have time to create an example for you. Why do you think you need 3 tables?</p><p>Have one table with group by department and product. Then after the table have 2 charts on the same data set, one grouped on department, the other without grouping.</p><p> </p><p>P.S. If the x-axis is time then a line chart is more appropriate than a bar chart.</p>