Jump to content
We've recently updated our Privacy Statement, available here. ×

How can I set up a dynamic cross/graphical table


Roni Bhakat

Recommended Posts

I have a sample data table which has 3 coulmns Year, Month and Cost. Now I want set up a cross table or graphical table where I can see cell value Avg([Cost]) when Vertical Axes is Year and another one is Sum([Cost]) when Vertical Axes is Month.

I could create it but then I have to create 2 different Document propertiesfor Vertical Axes and Cell Value. I want when Vertical Axes changes to Year or Month, cell value should also change accordingly. Please check my dxp file of my so far attempt. A help is much appreciated.

 

 

 

Year

Month

Cost

 

 

2017

Jun

51

 

 

2017

Jul

55.9

 

 

2017

Aug

60.8

 

 

2017

Sep

12

 

 

2017

Oct

10

 

 

2017

Nov

20

 

 

2017

Dec

22

 

 

2018

Jan

23

 

 

2018

Feb

33

 

 

2018

Mar

36.3

 

 

2018

Apr

41.2

 

 

2018

May

46.1

 

 

2018

Jun

51

 

 

2018

Jul

55.9

 

 

2018

Aug

60.8

 

 

2018

Sep

12

 

 

2018

Oct

10

 

 

2018

Nov

20

 

 

2018

Dec

22

 

 

2019

Jan

23

 

 

2019

Feb

33

 

 

2019

Mar

36.3

Link to comment
Share on other sites

  • 5 weeks later...
  • 3 weeks later...

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...