Forum Discussion

IF's avatar
IF
Post Prodigy
5 years ago
Solved

Matrix

Hi,

I have a bad data source.  The data example is Table:AC

 

CountryCityTownTypeMonthV1V2
Country1City1A05.20200.00185.3
Country1City1B05.20200.00285.3
Country1City1C05.20200.00285.3
Country1City2A05.20200.00283.3
Country1City2B05.20200.00283.3
Country1City2C05.20200.00383.3
Country1#A05.20200.00978.6
Country1#B05.20200.00878.6
Country1#C05.20200.00778.6
Country2City3A05.20200.00485.9
Country2City3B05.20200.00385.9
Country2City3C05.20200.00285.9
Country2City4A05.20200.02154.5
Country2City4B05.20200.02454.5
Country2City4C05.20200.07154.5
Country2#A05.20200.04167.8
Country2#B05.20200.00167.8
Country2#C05.20200.00767.8
##A05.20200.04167.1
##B05.20200.00167.1
##C05.20200.00767.1

 

I have also table: PL

CountryCityTownTypeMonthV3

Country1City1A05.20200.002
Country1City1B05.20200.002
Country1City2A05.20200.004
Country1City2B05.20200.002
Country1#A05.20200.002
Country1#B05.20200.008
Country2City3A05.20200.004
Country2City3B05.20200.008
Country2City4A05.20200.021
Country2City4B05.20200.029
Country2#A05.20200.041
Country2#B05.20200.011
##A05.20200.048
##B05.20200.001

 

I have also city and month tables that I connect the tables and use the columns from city and month table in the page.

I want to make a matrix and show total of A and B values at the column V1, V2 value and V3 value.

The file is available at the dropbox, which can be much easier to work on it: https://www.dropbox.com/s/5awowcof9xanuow/Q%20Table%20and%20Graph.pbix?dl=0

 

Thanks in advance!

Need Help