Forum Discussion
Transpose a matrix
Hi Anonymous ,
I am not quite sure whether the row fields in the matrix are hierarchical in your template. If it is, it may be difficult to implement your results. If not, you can try to convert the row and column fields in the matrix for swapping.
If it doesn't meet your requirement, kindly share your sample data if you don't have any Confidential Information.
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi v-joesh-msft ,
It is a funnel so yes it is hierarchial. PFA the sample data. Looking forward to hearing from you. Thank you!org_id org_name geo_code country market_segment contract_start_quarter Provisioned Sum of assigned_seats QAD Sum of downloaders downloads Assigned 1+ Assigned > 10% Assigned > 50% Consuming (1+) Consuming (10+) D874CD9D542D992A0A4C98 Brainlounge JPN JP COMMERCIAL 2017-Q4 58 11 0 0 0 1 1 0 0 0 ECBAE18C55352B350A4C98A6 JumpXS EMEA GB COMMERCIAL 2018-Q1 315 34 13 17 210 1 1 0 1 1 6BAE37875C936C6C0A495FBD Babbleset AMER US COMMERCIAL 2019-Q2 12 1 0 1 2 1 0 0 1 0 5AFA5F3E57057E367F000101 Innotype ASIA IN COMMERCIAL 2019-Q2 179 173 11 59 14 1 1 1 1 1 D029B4A35717B9957F000101 Zoomcast AMER US COMMERCIAL 2019-Q2 1054 1163 61 65 189 1 1 1 1 1 741524D15CBF274B0A495C93 Riffwire AMER BR COMMERCIAL 2019-Q2 42 42 2 7 6 1 1 1 1 0 5211508055C89B1F7F000101 Feedspan AMER US COMMERCIAL 2019-Q2 326 344 30 44 50 1 1 1 1 1 8EF1373B5CC1EE9F0A495FB9 Mydo EMEA NO COMMERCIAL 2019-Q2 50 71 2 3 1 1 1 1 1 0 518A4C4E572252707F000101 Tanoodle ASIA AU COMMERCIAL 2019-Q2 75 117 22 27 283 1 1 1 1 1 98B51C8B532961AB0A490D4D Brainlounge AMER US COMMERCIAL 2019-Q2 338 337 25 52 535 1 1 1 1 1 6FDF58DD55C1322D7F000101 Zava AMER US COMMERCIAL 2019-Q2 266 263 21 28 40 1 1 1 1 1 F859C4A65717BC3B7F000101 Quimm EMEA IT COMMERCIAL 2019-Q2 113 119 24 36 3996 1 1 1 1 1 4E6040D7544924950A4C98A2 Babbleblab EMEA SE COMMERCIAL 2019-Q2 320 360 7 7 26 1 1 1 1 1 9F55515C56B50A707F000101 Photobug AMER US COMMERCIAL 2019-Q2 167 189 15 28 91 1 1 1 1 1 6716FFD3544984240A4C98A5 Babbleblab EMEA FR COMMERCIAL 2019-Q2 1318 122 5 15 32 1 0 0 1 1 E97C63305747438F7F000101 Skipstorm AMER US COMMERCIAL 2019-Q2 126 126 6 15 4 1 1 1 1 0 B3902DB45388D9620A490D4C Jabbercube AMER US COMMERCIAL 2019-Q2 353 397 44 70 773 1 1 1 1 1 4CE5F16A5748AD3A7F000101 Realfire AMER US COMMERCIAL 2019-Q2 335 278 24 35 327 1 1 1 1 1 D57A2420546E39840A4C98A2 Zoozzy AMER US COMMERCIAL 2019-Q2 302 239 32 45 1360 1 1 1 1 1 5A67E38C5474FAAE0A4C98A7 Yakitri AMER US COMMERCIAL 2019-Q2 350 294 30 58 3171 1 1 1 1 1 9718FFD3545D05690A4C98A5 Tagcat EMEA AT COMMERCIAL 2019-Q2 66 65 1 2 3 1 1 1 1 0 9BB626F8545D1AFA0A4C98A4 Kaymbo EMEA DE COMMERCIAL 2019-Q2 157 172 6 23 30 1 1 1 1 1 17FAD312548B70250A4C98A6 Jayo EMEA BE COMMERCIAL 2019-Q2 107 108 10 29 44 1 1 1 1 1 19D21607552EBC000A4C98A2 Livepath ASIA AU COMMERCIAL 2019-Q2 78 75 14 17 334 1 1 1 1 1 914CA272551D23790A4C98A2 Mita AMER US COMMERCIAL 2019-Q2 771 654 63 75 540 1 1 1 1 1 A66F776A5245B0310A490D44 Photolist AMER US COMMERCIAL 2019-Q2 673 808 14 51 0 1 1 1 0 0 C1FA079F574F01297F000101 Lazzy AMER US COMMERCIAL 2019-Q2 306 273 28 73 418 1 1 1 1 1 D06DE27F546E24D40A4C98A5 Livetube AMER US COMMERCIAL 2019-Q2 394 399 59 85 977 1 1 1 1 1 EB2234B85CF1A76C0A495CD7 Shufflester AMER US COMMERCIAL 2019-Q2 402 455 54 100 193 1 1 1 1 1 42DF2BA2549484FB0A4C98A1 Realpoint AMER US COMMERCIAL 2019-Q3 2170 3 0 0 0 1 0 0 0 0 8AA1FCB555A95FD27F000101 Innotype EMEA AT COMMERCIAL 2019-Q3 719 709 71 81 1785 1 1 1 1 1 C2F4D3125489ED960A4C98A6 Kwilith EMEA DE COMMERCIAL 2019-Q3 12700 214 23 27 664 1 0 0 1 1 3D00286D5750980D7F000101 Tanoodle AMER US COMMERCIAL 2019-Q3 450 479 29 30 319 1 1 1 1 1 5741693F544944260A4C98A6 Chatterpoint EMEA SE COMMERCIAL 2019-Q3 56 52 12 7 60 1 1 1 1 1 5AE4E38C5474FC7E0A4C98A7 Skynoodle AMER US COMMERCIAL 2019-Q3 277 104 3 4 153 1 1 0 1 1 F718199053220B9F0A490D4C Mycat AMER US COMMERCIAL 2019-Q3 308 1 0 0 0 1 0 0 0 0 4A7BC38E5494B4220A4C98A2 Einti AMER US COMMERCIAL 2019-Q3 1300 1673 19 48 144 1 1 1 1 1 HI Anonymous ,
From your data, I found that there are fewer fields, such as Accounts Purchased/Under 30 Days into Contract, and the calculation logic of measure in the template is harder to find.
As mentioned in the previous reply, if the rows in your template matrix are hierarchical measures, this is hard to achieve. Based on the results you want to achieve, I think you can try to create a disconnected table, check out this article: Measures on Rows – Here is How I did it
Best Regards,
Community Support Team _ Joey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.