# Thread: Table calc with a slicer

1. Register for a FREE account, and/

Sorry
Couldn't resist playing about with a Pivot Table !

2. Try this Mike

3. Another possibility - Having set up the Pivot Table rather than a standard table, you can then connect slicers to it (as the attachment) provided your working with Excel 2010 and later. If you want to use slicers on other tables, you need Excel 2013.

4. With a pivot table, I could use the slicer, the just use a getpivotdata formula, but was really trying to avoid the pivot table altogether. However! Bobs solution worked like a charm. Does bring up another question tho, what does the double dash represent in this formula? I have never used that one.

5. Hello Mike
Glad we found the right solution for you. The double unary is a way to convert a string representation of a number into its number form (i.e. "123" into 123).

6. Interesting. One thing I put into charts is a text box under the chart to pull data in so they can see what the number is (such as Last weeks sales: N Average: N and o forth). To do this I have to put together a formula to concatenate the text along with the cell address to create the text. Calc works fine, right up till someone wanted me to insert commas into the number. Now I have to use the LEN along with the ROUND and CONCATENATE just to pull all the info together. Is it possible to just use the "unary" as you call it to do the same thing? Turn the number section into a number so it would automatically format as a number?

7. Originally Posted by Mike_Alex
Interesting. One thing I put into charts is a text box under the chart to pull data in so they can see what the number is (such as Last weeks sales: N Average: N and o forth). To do this I have to put together a formula to concatenate the text along with the cell address to create the text. Calc works fine, right up till someone wanted me to insert commas into the number. Now I have to use the LEN along with the ROUND and CONCATENATE just to pull all the info together. Is it possible to just use the "unary" as you call it to do the same thing? Turn the number section into a number so it would automatically format as a number?
Im inclined to think that it wouldn't work on its own, and in any case you can achieve the same end result by performing any mathematical manipulation. The easiest is to add zero to the string numeric, which doesn't alter the value of the resulting number.
I suggest that you open a new thread for this latest problem with an example showing the expected and actual results

8. I may have to do just that. Thanks for all your assistance there Hercules!

9. Originally Posted by Mike_Alex
However! Bobs solution worked like a charm. Does bring up another question tho, what does the double dash represent in this formula? I have never used that one.
It is all explained in http://www.xldynamic.com/source/xld.SUMPRODUCT.html

Page 2 of 2 First 1 2

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•