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?
Something like that just with your pivot grid:
https://www.homeworkhelponline.net/blog/programming/excel-pivot-sub-group
(measure) I want text as measure values.
See it so you work for a food catering service with companys in paris, Berlin, Mardid and so on.
you have the Meals:
Pizza
Burger
Lasagne
Spagetti
Free Choice which every possible text could be
for the 4 passible answers pizza, BUrger, Lasagne , Spagetti you mybe can make still a dimension it makes your pivot grid 4 times bigger since every result space (measure) you wanna show is reprenseted as 1 and the so you have for every day the 4 times more rows then you really need.
For checking if for example paris has enough of pizza this month the ccounts and number are great but if youwant easy use that same data for the hang out
where the dimension the Time is the measure should be the real name like pizza , burger and so on and the other side dimesion is then for example the filtered place paris, then a pivot with counts suck and the one you need is a list with as well text values in the results (measures)
Pentaho for example can something like that, good the id is a number but every measure value has a description you also can set. That way you can show the names instad of a 1 for that measure was taken or an null for that measure value wasn't taken.
What I want:
MO TH WE TH FR SA SU
8 am pizza, pasta, burger - - - -
13 pm - - - - - - -
17 pm - - - - - - -
What I currently get:
8 am pizza 1 0 1 - - - -
pasta 0 1 0 - - - -
burger 0 0 1 - - - -
13 pm pizza
pasta
burger - - - - - - -
17 pm pizza
burger- - - - - - -
First what I want everyone understand the other is good for anlyse like to check ho often had they in the month pizza , pasta and burger but as out fut for the comapany as meal list can you forget that view totally.
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.
Please let me know if you have any questions.
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.
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'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
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.