Roni Bhakat Posted January 14, 2020 Posted January 14, 2020 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
Khushboo Rabadia Posted February 12, 2020 Posted February 12, 2020 As you have dropdown document property for year or month, you can just setup cell value expression as If("${col}"="Year",Avg([Cost]),Sum([Cost])) as [Cost]
Roni Bhakat Posted March 2, 2020 Author Posted March 2, 2020 Thank you so much Khushboo. it works. Regards, Roni
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now