Forum Discussion

Narenthir's avatar
Narenthir
Frequent Visitor
3 years ago

Custom coloumn

If i combined the 2 cloumns then my values are wrong in the bar chart. But its shows correct value if changed to table.Help needed, Thanks in advance.

2 Replies

    • Narenthir's avatar
      Narenthir
      Frequent Visitor

      Hi Amit, Thank for the reply,
      I will give a little backround. My excel data consist of 3 to 4 text columns  and 8 Qtr(2years) colums. I do some query format change and look like this 

      After this apply and load. And i created running total measure for the value. And concatenate 2 colums(fab and Position) If plot the chart with seperate charts with  legend like (fab , hub, position) it works fine.

       

       

      When i used my concatenate coloumn(Fab & Position) the value dosent match

       

      I hope will get solution thanks.