Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
235
Single Total for multiple columns
posted

Hello,

Using the XamPivotGrid 13.1 I am trying to get a single total column when pivoting on 2 columns. I dont want to see totals per dimension, i just want a single total column at the end.

As an example, the code below makes a flat data source with city vertically and years + fruit horizontally           

          var flatDataSource = new FlatDataSource
            {
                ItemsSource = GenerateRandomData(),
                Cube = XmlaDataSource.GenerateInitialCube("Datum"),
                Rows = XmlaDataSource.GenerateInitialItems("[City].[City]"),
                Columns = XmlaDataSource.GenerateInitialItems("[Year].[Year], [Fruit].[Fruit]"),
                Measures = XmlaDataSource.GenerateInitialItems("Value"),
            };
            // Totals
            var cityHierarchy = new HierarchyDescriptor<Datum>(p => p.City);
            cityHierarchy.AddLevel(p => "City", "City Total");
            cityHierarchy.AddLevel(p => p.City, "City");
            flatDataSource.AddHierarchyDescriptor(cityHierarchy);
            var fruitHierarchy = new HierarchyDescriptor<Datum>(p => p.Fruit);
            fruitHierarchy.AddLevel(p => p.Fruit, "Fruit");
            flatDataSource.AddHierarchyDescriptor(fruitHierarchy);
            var yearHierarchy = new HierarchyDescriptor<Datum>(p => p.Year);
            yearHierarchy.AddLevel(p => "Year", "Year Total");
            yearHierarchy.AddLevel(p => p.Year, "Year");
            flatDataSource.AddHierarchyDescriptor(yearHierarchy);

With 2 years and 2 fruits, this produces a table with the following headers

2015/Banana, 2015/Apple, 2014/Banana, 2014/Apple, Year Total/Banana, Year Total/Apple

What i require is

2015/Banana, 2015/Apple, 2014/Banana, 2014/Apple, Total

Please see the attachment for a project showing the existing pivot grid and a screen shot of the required. For some reason i dont seem to be able to upload images to the forums.

PivotExample.zip
Parents
No Data
Reply
  • 16495
    Offline posted

    Hello Steven,

     

    Thank you for you post.

     

    After working on the functionality that you are trying to achieve and doing some research, the ability to create a single total column for multiples columns has been determined to be a new product idea. You can suggest new Product Ideas for future versions (or vote for existing ones) at http://ideas.infragistics.com.

     

    Steps to create your idea:

                   

    1. Log into the Infragistics Product Ideas site at http://ideas.infragistics.com (creating a new login if needed).

    2. Navigate to the product / platform channel of your choice (e.g. WPF, Windows Forms, ASP.NET, HTML5 / Ignite UI, iOS / NucliOS, etc.)

    3. Add your product idea and be sure to be specific and provide as much detail as possible.

    • Explain the context in which a feature would be used, why it is needed, why it can’t be accomplished today, and who would benefit from it. You can even add screenshots to build a stronger case. Remember that for your suggestion to be successful, you need other members of the community to vote for it. Be convincing!

    • Include a link to this thread in your idea so product management will be able to look back at this case. 

     

    The benefits of submitting the product idea yourself include:

    • Direct communication with our product management team regarding your product idea.

    • Notifications whenever new information regarding your idea becomes available.

       

      Additional benefits of the Product Idea system include:

       

    • Ability to vote on your favorite product ideas to let us know which ones are the most important to you.  You will have ten votes for this and can change which ideas you are voting for at any time.

    • Allow you to shape the future of our products by requesting new controls and products altogether.

    • You and other developers can discuss existing product ideas with members of our Product Management team.

       

      The product ideas site allows you to track the progress of your ideas at any time, see how many votes it got, read comments from other developers in the community, and see if someone from the product team has additional questions for you.

       

      Thank you for contacting Infragistics.

Children
No Data