Answer the question
In order to leave comments, you need to log in
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:
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:
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 questionAsk a Question
731 491 924 answers to any question