How to remove blank space?

0

I have crosstab with some data.

Article             |    2017       |          2018

Cities

     Chicago     |     23           |          44

Cities

     Vegas         |      12          |          23

Cities

     Kiev          |       44          |          12

Countries

     GB            |         5           |          2

Countries

     UA           |         4            |         13

Countries

     UK           |         8           |          7

How to remove repeated values and blank space?

bondarenkoigor1985's picture
Joined: Mar 19 2018 - 1:21am
Last seen: 1 year 10 months ago

1 Answer:

0

Found solution by myself!

Remove row with group name,

enable "total" field for product name row, 

replace total variable with group name variable.

bondarenkoigor1985's picture
Joined: Mar 19 2018 - 1:21am
Last seen: 1 year 10 months ago
Feedback
randomness