Interactive Data to change pricing
Hello,
I am trying to find the limits of Pyramid, so pardon me if this is impossible. I'd like to think that thee has got to be a way... even if it is complicated.
1) How do I get my data to show up on 2 lines within one "cell". In excel this is simple, but in P.A. I cannot find a way
2) What I'm hoping to be able to do is use a slicer (or something similar if there is a different option) in the present that would enable a user to click on one of the options, which would then dynamically change the pricing.
So, first off, can the text be assigned a value?
And Secondly, is it possible for a situation where a user could click on "UpchargeA1" (let's assume the value is $50.00) then the "Base Price" would change to $150.00 ($100.00 + $50.00).
If it can be done, but requires some coding, then could you give me a general idea what needs to be coded and I can pass it off to my counterpart who is much more skilled in coding than I am and have him write some code.
Having this type of functionality would enable me to blend a whole slew of products into 1 dynamic column.
EDIT: The value that would be assigned to the text is available in a separate column in my model. So - I would have column 1 containing the text (UpchargeA1), and column 2 containing the value (50) that I would like the text to represent.
6 replies
-
Hi Ricky, typically if we want to show data like your image above where it's 'grouped by' we add multiple dimensions to the "Rows" drop zone in a matrix grid. I may not be interpreting that first question fully though. If you are looking to essentially change the value of pricing based on whether it's UpchargeA1 or UpchargeA2, I could see this being done by creating a Parameter and then creating a Formula with a logical statement (Case, IF, etc) that returns different calculations based on the parameter or field value for 'Upcharge". In terms of clicking on "UpchargeA1", you could have that Parameter I mentioned take the form of a "Button" type of slicer.
Let me know if I am on the right trail for what you are asking, or if I'm oversimplifying it. I think this can definitely be done primarily within Formulate.
-
I'm putting together a comparison between products (100+) so having everything on separate rows makes it hard to read an gives it a cluttered look. If I am forced to keep the measures on separate rows, is it possible to merge the dimension and then nest the measures together (as shown using excel).
-
-
Thanks, those screenshots are helpful! Since you're In-Memory here, the first thing I would probably do is to add a String Left node in your data flow and take 8 characters (create column & keep original). Then, you can use that as your dimension and it will show the Example1, Example2, Example3 separately but still split out the Upcharges for each.
-
ok - so it groups the products (Example1A, Example1B, Example1C) when I use the string left, but the pricing and upcharges aren't separated. I need them to be on separate lines and not on 1 line separated by commas (,)
I think it should be added as a feature where TXT data can be separated by a line break (ALT+ENTER) instead of a comma.
-
-
From a display standpoint, if you go to the formatting panel and turn on "Wrap Text" you can get each Upcharge on a separate line. You would just want to remove the comma from the string. Then, make the Upcharges column narrower until it wraps the text.
I'll look into a solution for selecting individual upcharges from a single field though.
