Forum Discussion

Mays-Alreem's avatar
Mays-Alreem
Frequent Visitor
2 years ago

Combine two columns

Hi everyone, 

I have a data for 2 years, every year in a different table, they have city column but some cities vary (i.e in last year 2 cities combined in one different named column).

I want to but them in slicer but how can I combine two cities which belong to this year and make it affect other charts when selecting one last year cities name? To make comparison between last year and this year by city. 

 

As an example if this year we have European-Istanbul and Asian-Istanbul but last year we had just Istanbul as a whole, how can we sum the both European + Asian above and appear the result to all charts.

 

Many thanks 

Need Help

2 Replies

  • PijushRoy's avatar
    PijushRoy
    Community Champion
    2 years ago

    Hi Mays-Alreem 

    You can use below tricks, it is simple to implement & make your report clean
    1) Keep separate table for two years
    2) Create two pages report for two years
    3) Hind 2nd page
    4) In place of the slicer, use the Button for two years and this button will navigate between two pages (Button Action should be ) like this 

     



    Let me know if it works