[Skip to main content](#vessel-content) # Sales Report widget with a SUM capability ## - **[codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile")** - [![codewarrior's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4710-codewarrior "View codewarrior's Profile") Topic Author - [ Offline](/forum/user/4710-codewarrior) Less More - Posts: 190 - Thank you received: 0 - - 14 years 1 week ago [\#73965](#73965) by [codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile") *[Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#73965 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* was created by *[codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile")* Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 14 years 1 week ago [\#74133](#74133) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Re: Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#74133 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* Hi there, Referring to [ the documentation](http://www.hikashop.com/en/support/documentation/133-hikashop-report-form.html) you can do this with the table widget. Firest, create a new table widget and then add a new line with the sales for the period you wish. It should do what you expect ![:)](/media/kunena/emoticons/3.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile")** - [![codewarrior's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4710-codewarrior "View codewarrior's Profile") Topic Author - [ Offline](/forum/user/4710-codewarrior) Less More - Posts: 190 - Thank you received: 0 - - 14 years 4 days ago [\#75558](#75558) by [codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile") Replied by *[codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile")* on topic *[Re: Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#75558 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* Thanks Eliot, it sounds good, but after creating a table widget, a pop-up is opening with a "Please configure your first row" message. Whatever I configure, when I click on the OK button, the popup don't close and nothing is saved. Do you have an idea ? Regards Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 14 years 2 days ago [\#75817](#75817) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Re: Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#75817 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* Sounds strange... Did you try with another browser? If yes I'd be interested by an access to your backend to check if there is any javascript error or anything similar. Try with Chrome or Firefox and PM me if it doesn't allow you to create your row. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile")** - [![codewarrior's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4710-codewarrior "View codewarrior's Profile") Topic Author - [ Offline](/forum/user/4710-codewarrior) Less More - Posts: 190 - Thank you received: 0 - - 14 years 2 days ago [\#75867](#75867) by [codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile") Replied by *[codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile")* on topic *[Re: Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#75867 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* Hi Eliot, I use Firefox 16 (last version) Nicolas has access to my Production backend. I'll sent it to you this evening if you can't have it. Regards Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 14 years 1 day ago [\#76086](#76086) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Re: Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#76086 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* As you may have noticed, I fixed the popup bug on your website. However it looks like you still have a problem since amounts are always empty. I'll try to take a look at this as soon as possible ![:)](/media/kunena/emoticons/3.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile")** - [![codewarrior's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4710-codewarrior "View codewarrior's Profile") Topic Author - [ Offline](/forum/user/4710-codewarrior) Less More - Posts: 190 - Thank you received: 0 - - 14 years 1 day ago [\#76206](#76206) by [codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile") Replied by *[codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile")* on topic *[Re: Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#76206 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* Thanks Eliot, I thougt I was crazy (working without any modification) Could you tell me the modifications, even if I suppose that you will integrate them in the next versions, because I always fear upgrades. Regards Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")** - [![olivnewton's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9482-olivnewton "View olivnewton's Profile") - [ Offline](/forum/user/9482-olivnewton) Less More - Posts: 154 - Thank you received: 4 - - 14 years 19 hours ago [\#76308](#76308) by [olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile") Replied by *[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")* on topic *[Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#76308 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* same problem here guys. could you please tell me how to fix this? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 13 years 11 months ago [\#76607](#76607) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#76607 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* It's a Javascript issue. Edit the tableform view and replace the code between the php tag by this one: Code: $access=""; $access2=""; if(hikashop_level(2)){ $access="access = parent.window.document.getElementById('widget_access').value;"; $access2="document.getElementById('access').value = access;"; } $jsOnClick=" var published = 1; name = parent.window.document.getElementById('name').value; publishedNo = parent.window.document.getElementById('data[widget][widget_published]0').value; ".$access." if(publishedNo){ published=0 } document.getElementById('name').value = name; document.getElementById('published').value = published;" . "".$access2." submitbutton('apply_table');"; Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")** - [![olivnewton's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9482-olivnewton "View olivnewton's Profile") - [ Offline](/forum/user/9482-olivnewton) Less More - Posts: 154 - Thank you received: 4 - - 13 years 11 months ago [\#76681](#76681) by [olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile") Replied by *[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")* on topic *[Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#76681 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* hi eliot, could you please be more precise? i guess / hope you mean: administrator/components/com_hikashop/views/report/tmpl/tableform.php if yes, then what do you mean by "replace the code between the php tag"...? roughly at what line? there are a lot of php tags, and none seems to be close to the code you suggested... but then again, you might be talking about a different file. Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 13 years 11 months ago [\#76684](#76684) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#76684 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* My bad, I've been to quick on this point ![:)](/media/kunena/emoticons/3.png ":)") You just have to go in Display>Views and look for the tableform file I'm talking about (it's in the dashboard view, be sure to edit the file of your template). And the code you have to replace by this one is quite similar. It's at the begining of the file and looks like the one I gave you. Just select everything inside these first tags and replace it. It should do the job ![:)](/media/kunena/emoticons/3.png ":)") The following user(s) said Thank You: [codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile"), [olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")** - [![olivnewton's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9482-olivnewton "View olivnewton's Profile") - [ Offline](/forum/user/9482-olivnewton) Less More - Posts: 154 - Thank you received: 4 - - 13 years 11 months ago [\#76685](#76685) by [olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile") Replied by *[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")* on topic *[Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#76685 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* well, the last part of the first <php>-tags is similar, i will try that Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")** - [![olivnewton's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9482-olivnewton "View olivnewton's Profile") - [ Offline](/forum/user/9482-olivnewton) Less More - Posts: 154 - Thank you received: 4 - - 13 years 11 months ago [\#76687](#76687) by [olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile") Replied by *[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")* on topic *[Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#76687 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* ah! great! i will try that via display>views, thanks a lot Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")** - [![olivnewton's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9482-olivnewton "View olivnewton's Profile") - [ Offline](/forum/user/9482-olivnewton) Less More - Posts: 154 - Thank you received: 4 - - 13 years 11 months ago [\#76695](#76695) by [olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile") Replied by *[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")* on topic *[Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#76695 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* ok, i did that, but i still get the error. i guess i have to select the template i changed for the backend? cannot find where / how... any suggestion? Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")** - [![olivnewton's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/9482-olivnewton "View olivnewton's Profile") - [ Offline](/forum/user/9482-olivnewton) Less More - Posts: 154 - Thank you received: 4 - - 13 years 11 months ago [\#76701](#76701) by [olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile") Replied by *[olivnewton](/forum/user/9482-olivnewton "View olivnewton's Profile")* on topic *[Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#76701 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* got it! was a bit irritating to do this via hikashop>backend, because there it shows me also a backend template with the name of my custom site-template. so i thought i select that... but i had to select "the global backend joomla template i am using" Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile")** - [![codewarrior's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4710-codewarrior "View codewarrior's Profile") Topic Author - [ Offline](/forum/user/4710-codewarrior) Less More - Posts: 190 - Thank you received: 0 - - 13 years 11 months ago [\#77799](#77799) by [codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile") Replied by *[codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile")* on topic *[Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#77799 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* Eliot, to be more precise : If you use backend template Bluestork, the file "tableform" is in "report" view. Thanks for your help. Regards Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 13 years 11 months ago [\#78146](#78146) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#78146 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* You're right ![:)](/media/kunena/emoticons/3.png ":)") About your problem, try to update to Hikashop 2.0, the SQL request are quite different and it may solve everything Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile")** - [![codewarrior's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4710-codewarrior "View codewarrior's Profile") Topic Author - [ Offline](/forum/user/4710-codewarrior) Less More - Posts: 190 - Thank you received: 0 - - 13 years 11 months ago [\#81742](#81742) by [codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile") Replied by *[codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile")* on topic *[Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#81742 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* Eliot, I updated to V2.0 Table widget is better, but : - each time, I edit, it's still going unpublished, - all rows values are 0, - the delete icons are with no effect (Firefox 16 & IE9) - the edit icon opens a popup with : 1) "New row" (for all rows) on the site where you've done modifications (I don't which ones) 2) the opposite row of the list, on another DEV site - a click on the "Add" button of the table opens the 2nd item. Please could you please definetly find a solution to that problem, before adding new options in newer versions. Regards Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[Eliot](/forum/user/1824-eliot "View Eliot's Profile")** - [![Eliot's Avatar](https://www.hikashop.com/media/kunena/avatars/resized/size144/users/avatar1824.png)](/forum/user/1824-eliot "View Eliot's Profile") - [ Offline](/forum/user/1824-eliot) Less More - Posts: 2334 - Thank you received: 403 - - 13 years 11 months ago [\#82014](#82014) by [Eliot](/forum/user/1824-eliot "View Eliot's Profile") Replied by *[Eliot](/forum/user/1824-eliot "View Eliot's Profile")* on topic *[Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#82014 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* Hi there, I'm sorry but don't have your FTP informations anymore... :blush: Could send me a PM again so I take a look at it right now? Thanks ![:)](/media/kunena/emoticons/3.png ":)") Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. - **[codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile")** - [![codewarrior's Avatar](https://www.hikashop.com/media/kunena/core/svg/person.svg)](/forum/user/4710-codewarrior "View codewarrior's Profile") Topic Author - [ Offline](/forum/user/4710-codewarrior) Less More - Posts: 190 - Thank you received: 0 - - 13 years 10 months ago [\#83156](#83156) by [codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile") Replied by *[codewarrior](/forum/user/4710-codewarrior "View codewarrior's Profile")* on topic *[Sales Report widget with a SUM capability](/forum/2-general-talk-about-hikashop/73965-sales-report-widget-with-a-sum-capability#83156 "Hi, I would like to get the amount of all my sales. It's only possible to have the detailed list. If there is not already a trick, is it possible to have a widget with a SUM capability ? Regards")* Hi Eliot, I sent you a PM. Did you had time to look at my problem ? Thanks. Regards Please [Log in](/login?return=aHR0cHM6Ly93d3cuaGlrYXNob3AuY29tL2ZvcnVtLzItZ2VuZXJhbC10YWxrLWFib3V0LWhpa2FzaG9wLzczOTY1LXNhbGVzLXJlcG9ydC13aWRnZXQtd2l0aC1hLXN1bS1jYXBhYmlsaXR5P3N0YXJ0PTAmdG1wbD1tYXJrZG93bg==) or [Create an account](/component/users/registration?Itemid=101) to join the conversation. Board Categories HikaShop Install & Update Product & Category Display Content Creation Sales and Orders Orders management Reports & Statistics Customers Checkout Payment Methods Shipping Methods Import & Export (CSV, XLS…) Specific Features Affilation Taxes Wishlist Vote Carousel & Slider Mass Actions Filters & Search Discount & Coupon Feature Request Integrations Showcase General Talk about HikaShop Development HikaShop 3.0 Beta Translation Commercial Jobs HikaShop Components HikaMarket Market: Feature requests Market: How to? Market: Bug Report HikaSerial General talk about HikaSerial Serial: Bug Report Serial: How to? Support en Français de HikaSerial (French Support) HikaSubscription HikaAuction Auction: Feature requests Auction: How to? Auction: Bug report Hikashop around the world Support en Français (French Support) Russian FAQ. Курс выживания с Hikashop. Частые вопросы и о Расширения Hikashop Наши сайты на Hikashop 日本語版サポート(Japanese Support) Thai German Archives Bug Report How to? [](/forum/topics/feed/mode-topics?format=feed&type=rss) Time to create page: 0.095 seconds [Powered by](/forum/credits) [Kunena Forum](https://www.kunena.org)