set analysis

[mario-sarkis]

hey,

here is  my question,

my data form is

branch      network   amount    year

byblos        X               1000           2012

bybos        X                500             2013

beirut          Y               500             2014

jounieh        X              2000           2013

tripoli           Y              1000          2021

i need to show a bar a chart compare

sum of amount of each branch  VS average of the network  (By year )

         than you

[Anonymous]

I suggest, you try something first.. and then post a question where you are getting stuck.. is it with a formula or something... or write a set analysis an then post it asking help in correcting it..

[sunny_talwar]

So you want a bar chart with year and branch as dimension and two expressions??? Not entirely sure what you requirement is. Would you be able to elaborate on expected output

Best,

Sunny