M
M
Max Trophy2016-08-19 13:15:04
SQL
Max Trophy, 2016-08-19 13:15:04

SQL query - is it possible to write zeros instead of grouping?

Hey!
It is necessary to form a report from the HD and upload it to Excel. In the uploaded Excel, the filter does not work due to groupings, so you have to make the report look like this ugly:
dcba3e3bae2446fca8a866ad8fe858c5.PNG
The fact is that considering this beauty, you might think that there are 300 sales in Russia, but in fact there are 100
. to mislead users, I want to do this:
f3edbad0136c4153b877258ed8d158b8.PNG
I ask for help from more experienced comrades.
upd:
grouping is not possible due to a Microsoft bug. Microsoft itself advises not to use groupings if you need to upload to Excel. Written here: https://msdn.microsoft.com/en-us/library/dd255234.aspx

Answer the question

In order to leave comments, you need to log in

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question