4 Replies Latest reply: May 15, 2014 10:16 AM by FoongCO _ RSS

    Across Key in Summary

      As I know,Monarch Pro 11 cannot display two across key in a summary.I have tried a workaround by creating some calculated fields to do the "grouping".I have to group the data by branch,sector and year.The two across keys are year and sector.To explain this,after i group by year,i group by sectors(like private sector and government sector).To do so, i created a counter(calculated field) for each sector.If the sector is government,then i will count as 1,else 0.Then i do same for the other sectors. Then in the summary,i use these counters(Calculated fields) as measures.But is there a more efficient way to do this?

       

      I am using Monarch Pro 11.

      Thank you.