Hi I know from other olap Sytems that you can use measure also as a kind of string value output and that kind I searching for.
If I declare a measure in my flatdatastore as number like int it appair in the measure choice, if I declare a string as measure and really need that one as measure it switch to dimension and I have no measure of that kind.
Something like the one below I need and for that I really need the none numerical values as measure.
I goes more komplex with some more dimension i do plan for it but the example below should be allready show what I really need ;)
Question 1 (Shift) | Question 2 (status) | Guestion 3 (Person in charge)
Year:2008 Department 1| Answer 1: night Shift | Answer 2: done| None | Mister X
Department 2|| Answer 1: morning shift | Answer 2: in process | Mister Y
Department 3|| Answer 1: none | Answer 2: none | Mister Z
Would be very great if you could help me since I need it very much ;)
Q=Question
Year=Year
D=Department
A=Answer (non numerical measure)
Q1|Q2@3
Year D1 A1|A2|A3
D2 A1|A2|A3
D3 A1|A2|A3
Hello,
I'm not certain what you are asking for. Can you please provide some more detail about your question?
Thank you for your more thorough explanation of your requirement. In order to accomplish this with UltraPivotGrid, you will need to modify your data source. UltraPivotGrid does not support this functionality at this time. I recommend submitting converting measures to string data as a new product idea: http://ideas.infragistics.com/forums/192359-windows-forms.
Please let me know if you have any questions.
I'm kind in a hurry and can't wait for a mybe feature ;)
Since our SOftware is full of your lib , I give it 1 more try.
Did Read in the forum about a way date from 01/01/2017 13:30 to change to just date with the action behind the pivotgrid cells.
That version was using the data type to change the datetime to date in all cells. if you have 2 date and datetime cloumns that hint would also kind a suck, when you just want in 1 the date and time and in the other just date.
How ever is there a way to see from which measure for example a cell comes?
My Idea would be to place in the measure cells intager ids and would then exchange them to the real value they have like pizza 1 and with that trick the 1 exchanged to pizza in the results and so on.
If not possibile in the win pivot grid is it maybe in the wpf version possible?
I know pentaho did cost 30k a year and your lib guess 2l-3k 1 time but that feature really is sonething which is in olp common sence ^^.;)
Pentaho and Jaspersoft did go further you een could aggregate with , so if you have a week pizza , burger, pizza, pasta , burger then the , string ebfore came out as totalk for this week. We really need that feature for our software.
Good the , summ not there is ok if it is a count
Damm cell.text is readonly ^^ why? You have allready cell.value where you can store the right value so it's stupid to make the text version as well readonly ^^
Good could anyway not figure out which cell is then from my measure but still why the hack is cell.text readonly ^^
^Hope the WPF Version has not that messup as well ^^
I will discuss this feature with our team and we will discuss that the other products have this capability.
As for the Text property, I believe it was made readonly because its actual value is derived from the cell.Value property and we wouldn't be able to correctly update Value when Text was changed programmatically. I will confirm this with my team.
I talked to my team about the measure to cell value feature. Our recommendation is to submit it as a product idea (at the previously provided link). Please mention the other products that use this feature, so that our dev team can see the feature in action and get a better understanding.
As for the text property being readonly, it's a combination of a few things. The actual text of a cell depends on many things, such as the cell value, formatting, and any applied masks. Cell text would need to be interpreted differently depending on the data type of the cell.